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?
Solved! Go to 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!
Hello @TMMK64571 ,
Could you please share the error message you receive when the flow has been run.
Thanks
-Josh
Proud to be a Flownaut!
Is this sufficient?
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
Proud to be a Flownaut!
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.
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 **
Proud to be a Flownaut!
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,
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!
User | Count |
---|---|
91 | |
40 | |
23 | |
20 | |
16 |
User | Count |
---|---|
128 | |
49 | |
47 | |
27 | |
27 |