Insdie MS Flow how i can build an email array from a "People or Group" which accept users and groups

Question

I have the following field inside my sharepoint for:-

and i want to send approval emails to all the group/s members (if any) + the individual user/s (if any):-

now i read this link @ https://alextofan.com/2019/10/02/how-to-send-approval-requests-to-groups-in-microsoft-flow/ which mention that i can get the members of a group, but in my case i need this to be dynamic + how i can check if the entity is an individual users or group (sharepoint group OR SharePoint group)?

Thanks

Answer 1

Hi @john john ,

I don't think we could retrieve Users or Groups seperately from a “People and Groups” column in flow.

Currently, Flow doesn’t let us assign directly to anything other than an email address.

It's necessary to get all user emails from SharePoint groups or office 365 groups first, than send the approval.

For more information, please refer to:

https://wonderlaura.com/2020/01/27/power-automate-approval-to-office-365-group-members/

intelogy.co.uk/blog/assigning-microsoft-flow-approvals-to-sharepoint-groups/

Note: Microsoft is providing this information as a convenience to you. The sites are not controlled by Microsoft. Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. Please make sure that you completely understand the risk before retrieving any suggestions from the above link.

---

If an Answer is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.