cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
irene
Frequent Visitor

Email sharepoint group

Hi, 

l am trying to send an email to sharepoint group, i used Send an HTTP request to sharepoint to get the emails,

_api/web/sitegroups/getbyname('GroupName')/users?$select=Email

then Parse Json but i get the error: ExpressionEvaluationFailed. The execution of template action 'Apply_to_each_10' failed: the result of the evaluation of 'foreach' expression '@body('Parse_JSON')?['d']?['results']' is of type 'Null'. The result must be a valid array.

in the output the email exists, the SP Group is not empty.

but flowproblem.PNG

2 REPLIES 2
v-bacao-msft
Community Support
Community Support

Hi @irene ,

 

You could consider using the action provided by Office 365 group connector to get the user's email.

 

  • Configure List group members action, select the specified SharePoint group, and then send an email to the user.

28.PNG

  • Or just send an email to all users, as below:

29.PNG

Please take a try.

 

Best Regards,

Community Support Team _ Barry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-bacao-msft , does the drop down list show your Sharepoint Groups? In my case it only shows my Office 365 groups (aka the Outlook ones)

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,938)