Power Automate to Check if a person exists in a SharePoint group

[Anonymous]

Hi all, 

I am creating a flow which would check whether  selected person is included in the SharePoint group, and if yes, then send an email.

My approach, which fails at step 3:

1. get the email as string value from the Sharepoint by initializing and appending string variable;

2. get the members of a SharePoint group by sending HTTP request to SharePoint

3. create a condition which would check whether the body from step 2 contains the email address retrieved in step 1

I have also tried using O365 List group members connector, but i enter my group's id as a custom, I get the error: 

Flow save failed with code 'OpenApiOperationParameterValidationFailed' and message 'Input parameter 'groupId' validation failed in workflow operation 'List_group_members': The parameter with value '"ResponsibleManagers_CNS"' in path 'groupId' with type/format 'String' is not convertible to type/format 'String/uuid'.'.

Also tried filtering the "Send an HTTP request to SharePoint" out to array using the following expression, but failed. 

contains(string(item()?['Email']),'@{@{triggerBody()?['Responsible_manager']?['Email']}')

Could someone please advice what could the possible solution? 

[PrasadAthalye · Accepted solution]

@Anonymous  - Unfortunately, Power Automate does not have any actions that work with SharePoint group. Its a must add. 

Try following link and see if you can use REST API...

https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/SharePoint-Group-Operations-in-Microsoft-Flow/ba-p/394446

Please like and mark this as solution if it resolves your issue.

[Anonymous · Accepted solution]

@PrasadAthalye, many thanks for the link! I also found some example and solution on YT: 

Get Email Addresses for Members of a SharePoint Group with Power Automate (Microsoft Flow) 

Final solution looked liked this:

[PrasadAthalye]

I am glad it helped...