Using String Variable with Send an HTTP request to SharePoint

[TMMK64571]

I am attempting to work around Flow sending the email from me by sending the email via SharePoint.  I have been able to use this with one of my processes successfully as a test, but I need to go a step further and gather a group of emails from a complementary List rather than hard coding the email or using the email field from the target SharePoint list.

Mikael Svenson's Post on Sending e-mails in Flow using SharePoint 

I have created a String Variable with the list of users emails who need to receive, but the Flow fails because the Variable is not recognized.  How can I update this to fix the error?

[Jcook]

Hello @TMMK64571 ,

Could you please share the error message you receive when the flow has been run.

Thanks

-Josh

[TMMK64571]

Is this sufficient?

[Jcook]

@TMMK64571 

Could you put a Data Operations - Compose action After the Foreach loop(outside) . And use the Email variable as the input. Run flow with that and screenshot the output of the Compose action please.

Thanks

-Josh

[TMMK64571]

Oh!  I like this check point addition.  Thank you!  Because I am in the testing phase, mine is the only email in the String currently.

[Jcook]

@TMMK64571 , 

How many emails are suppose to be in the variable after the loop?

Please try this..

- Go to your loop settings,

- Turn on Parallel Control

- Set to '1'

Here is some pics to guide you.

if this does not solve your problem, i would guess you need to use a Array Variable instead and than use append to array.

Thanks

-Josh

** If my reply helps, please 'Like' my comment **

[v-bacao-msft]

Hi @TMMK64571 ,

Please try to change the type of variable to array and use Append to array variable.

And there is no need to add a semicolon after the value.

Add variables directly after To when configuring the body of Send an HTTP request to SharePoint action.

Like:

Please try again.

Best Regards,

[TMMK64571 · Accepted solution]

I realized in the shower this morning, as has been pointed out in one of the replies, that I don't need the semi-colon because that was for the Outlook Send Mail action.  I revised the Append to String to change what was being fed in to SharePoint to include apostrophes with a comma for each entry and it fixed the issue.  Thank you to everyone for the assistance!

[lottidah]

Thank you so much for posting your solution!  I've spent all day trying various tweaks without success.  The ',' is what I needed.