cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
TMMK64571
Helper I
Helper I

Using String Variable with Send an HTTP request to SharePoint

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?

 

Step_1.PNG

Step_2.PNG

Step_3.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
TMMK64571
Helper I
Helper I

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!

Solution.PNG

View solution in original post

7 REPLIES 7
Jcook
Super User
Super User

Hello @TMMK64571 ,

 

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

 

Thanks

-Josh


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





Is this sufficient?

MailError.PNG

@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


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





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.

Output.PNG

@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.

 

pic2.pngpic3.png

 

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 **


Did I answer your question? Mark my post as a solution!

If you like my post please hit the Thumbs Up


Proud to be a Flownaut!


Check out my blog for Power Automate tips,
tricks, and guides
FlowAltDelete





v-bacao-msft
Community Support
Community Support

 

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:

69.PNG

Please try again.

 

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.
TMMK64571
Helper I
Helper I

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!

Solution.PNG

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,793)