Hello, can somebody please help me?
I'm trying to build a flow to send an email to everybody in my SharePoint group. I followed some instruction on the internet and used Send HTTP Request action, Select data operation, Join data operation, and then Send an Email (V.2) using the output from the Join step.
From what I can tell, the output came out of the Select data step as array successfully (or maybe I'm wrong), but for some reason, the Join operation doesn't work as it should, it doesn't format the array as the string of email (separated by semi-colon) like what people on the internet said. If somebody could please take a look and tell me what I did wrong, that would be greatly appreciated!
Here is my flow
the expression on the From line is body('Send_an_HTTP_request_to_SharePoint')?['d']?['results']
and on the Map line is item()?['Email']
on the Join step, I used the dynamic content of Output from the Select step and put in semi-colon on the Join With line
and then on the sending email step, I used the output from the Join step, and I got this huge error.
It looks like the Output from the Join step didn't come out in the email address format, but came out still looking like objects.
And I'm pretty sure the Output from the Select data step came out an array as it's wrapped in [ ].
I don't know why the Join function wouldn't treat it as array, anybody can help shed some light?
Thanks!
