Skip to main content
Nintex Community Menu Bar

Filter a List by a delimited field in a Form.

  • May 14, 2020
  • 1 reply
  • 4 views
  • Translate
K

Hi All,

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.

Company  Requestors

GBB110, bob.builder@bbc.co.uk;wendy.builder@bbc.co.uk

GBB100, bob.builder@bbc.co.uk

 

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.

Regards,

K

    Did this topic help you find an answer to your question?

    1 reply

    allan
    Forum|alt.badge.img+9
    • allan
    • Rookie
    • 177 replies
    • May 18, 2020
    You will not be able to do it that way. There's no possibility to filter with something like "if Requestors field contains this value". You cannot do it in CAML, neither. Maybe with using OData request.
    The best way to do it is to change your list so the key is the user (title field for instance) and the second field (company) should be a choice or a lookup.
    Translate

    Reply


    Sidebar Buttons
    Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
    Terms & ConditionsCookie Settings

    Cookie policy

    We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

     
    Cookie Settings