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

john john 946 Reputation points
2021-02-05T09:52:04.437+00:00

I have the following field inside my sharepoint for:-

64380-121.png

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

64427-msflow1.png

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

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,836 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. JoyZ 18,046 Reputation points
    2021-02-08T02:06:51.77+00:00

    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.

    65092-image.png

    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.