cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
renefigueora
Regular Visitor

List all sites a User has access to

Hello, 

I have been racking my brain on whether or not it is possible to some how pull one list(A) of all sites and their users. Then reference that list with another list(B) of specific users. 

Basically checking if the user in List B exists in List A and pulling all sites along with it. 

Any ideas?

1 REPLY 1
AnthonyAmador
Community Support
Community Support

Hi @renefigueora 

 

I created this example, I hope help you with what you want to do. 

 

AnthonyAmador_0-1631913676359.pngAnthonyAmador_1-1631913770254.png

 

AnthonyAmador_2-1631913864099.png

AnthonyAmador_3-1631913911154.png

AnthonyAmador_4-1631914158791.png

 

This is the final result 

AnthonyAmador_5-1631914227509.png

 

Basically what the flow does is compare the first name in List A with all the all the names in List B, then compare the second and so on, you need to be careful when selecting the correct dynamic value in the name and the site in the item to update if you want to update it, if not you can add whatever action you need there.

 

Hope this helps.

Best Regards. 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

 

Helpful resources

Announcements
Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Users online (2,343)