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?
Solved! Go to 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...
Please like and mark this as solution if it resolves your issue.
@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:
@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...
Please like and mark this as solution if it resolves your issue.
@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:
I am glad it helped...
User | Count |
---|---|
96 | |
40 | |
25 | |
22 | |
16 |
User | Count |
---|---|
129 | |
51 | |
48 | |
35 | |
24 |