I need to restrict my users' access to certain business units based on their account.
I have 2 fields in the SharePoint list - Company, Requestors.
The Requestors field is a semi-colon separated list.
So I only want the Companies where the Current User's Email is in the Requestors field.
So if Wendy is logged on, she can only see GBB110 in the List Lookup.
I have tried many variations of fn-contains() with no success.
Yes, I have tried this using a table with multiple records for each Company, but the Business has rejected that solution based on their level of maintenance.
Any help is appreciated.