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
Hi @irene ,
You could consider using the action provided by Office 365 group connector to get the user's email.
Please take a try.
Best Regards,
@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)
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
69 | |
27 | |
22 | |
16 | |
13 |
User | Count |
---|---|
132 | |
44 | |
43 | |
34 | |
31 |