Power Platform Community Forum Thread Details

There are multiple ways to do this and would like to hear what you have found to be the best and quickest method to do so.

I have a sharepoint list that has a LOOKUP field which has a multiple choice field. The user can select any number of options, as a result the Role field can have multiple values.

The sharepoint list if rather long and would like to parse the data as efficiently as possible. Since its a lookup column it doesnt seem like I can filter the sharepoint query, so I would have to bring in the data and filter it some other means.

Basically, would like to search for specific unique value in any of the Role positions and if the value exists, add the persons name (Name column) to a semicolon delimited string (which will be used for emails).

Last tidbit of info, is that there could be a single inquiry (value to search the Role column) or multiple.

Any help would greatly be appreciated

Categories:

Building flows