Get group members dynamically based on groups selected in library column

[leemc]

Hi, I have a library that I need to assign item level permissions on. In order to grant permission to the correct group, I have created a People picker column (groups allowed).  Column name is "Target groups". Some items may have multiple groups assigned permissions on them. At the moment these groups are AD security groups, synced to M365, but I could just as easily create SharePoint groups.

When I hardcode the group name (eg. TestGroup) into my "Send an HTTP request to SharePoint", the request is successful, but when I try to dynamically get the group members based on the group entered in the "Target groups" column, the operation never completes.

This completes successfully:

This does not end:

Is there any other way to dynamically get group members

[Expiscornovus]

Hi @leemc,

If it's a single AD security group per field you could use the claims value of the Target Groups field.

Add a Get group members action to your flow and use the following expression. Btw, in my example below I am collecting the value via a Get items action.

split(outputs('Get_items')?['body/value'][0]['Targetgroups'][0]['Claims'], 't|')?[1]

[tom_riha]

Hello @leemc ,

does the dynamic content 'Target groups' you use inside the 'Apply to each' contain only the group name? If you store it into a 'Compose' action inside the loop, does it contain only the group name?