cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Compare two lists and iterate multiple people in people picker

I have two lists in SharePoint and I am comparing on an office location column. If the values in the two columns match then I want to grab all of the values from an associated column that holds multiple username values. I need to to use each of these users to force a permissions change on an individual list item. I will have to iterate through or apply the permissions change to each of the users listed in the multiple value people picker.  While I understand the basics for the permissions change, I don't understand how to compare two lists AND I don't understand how to apply to each of the users.

 

Thanks,

ADove

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Compare two lists and iterate multiple people in people picker

Hi @adove,

 

I have made a test on my side to create two lists on my sharpeoint:

List A with a Single line of text column office location.

List B with a Single line of text column office location, and a Multi-Choice column username.

 

You could refer to my screenshot below to get compare two lists and I apply to each of the users:

Capture.PNG

 

Best regards,

Alice

 

Highlighted
Helper II
Helper II

Re: Compare two lists and iterate multiple people in people picker

As per your screenshot example, I don't show the same object at the end of your example. I don't have a "username" or similar field to select in the "Apply to each 3" step. The only steps I show include: Current Item (for Apply to each 2 and for Apply to each 3), and a value field (for each of the list objects). 

 

Any suggestions?

adove

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,226)