Forum Discussion
Update list items manually in sharepoint using power automate
Hello,
I have list , in which i want to update each list items permissions manually, means i want to trigger power automate flow manually once only, but I am not able to find any task in power automate where I can iterate each list item and update them
is there any task to iterate each item of the list
rautchetan27 it's happening because by default Get items only returns the first 100 items. You need to go to the Settings (3 dots at the top right) for the Get items, turn on the pagination toggle and change it to something like 2000.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
14 Replies
rautchetan27 you need to get the items from your list, then add an Apply to each and inside that apply to each add a Grant access to an item or a folder action. If you are removing access you could add a Stop sharing an item or folder action instead.
Rob
Los Gallardos
Microsoft Power Automate Community Super Userin my Filter query of "Get items"
Vendor eq 'IT'
where Vendor Column type is Group/users and not String/Text , thats why above query is not working.
I want to compare Vendor columns DisplayName with String.
How I can do that?
rautchetan27 : You can also store the user claims in the string variable and compare.
I want to user Filter query on Get Items, on the column of type users/groups
Users/Group Column DisplayName must match with one value in string variable.
how I can i do this comparision, because column which type is groups/users is not string so comparision is not working..
any idea?
rautchetan27 you can't use a Person/Group column in a Filter Query.
So you need to get all the items from the list and then add a condition that checks if the Vendor DisplayName contains the name of your Vendor.
If you want to do something with all the Vendors then you could do this with a Switch control based on the Vendor DisplayName and in each case you'd add the actions related to that Vendor.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
