Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Email sharepoint group


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


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

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.


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


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

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)