Answered

Generate Email from New Sharepoint Item - Email Contains Sharepoint Choice Data

(0) Share

Report

Posted on by jacobmmurphy5

Hello There!

I have a flow set up to send out an email when a new item is created in a sharepoint list. I would like the email to include data from the sharepoint list, including choice data. When I add the "Value" data to the email, it add a "For Each" loop in the flow. This is causing multiple emails to be sent out and incorrect data to be included (I think this is due to the order of the "For Each" loop). I do not have an issue with other data being included in the email such as date and regular lines of text.

Any advice?

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

ScottShearer 25,277 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!
@jacobmmurphy5

Try this:

Before the Send an email action, initialize a string variable

Add an "Append to a string variable" action

Select the column that is causing the loop followed by a comma and a space so there is a separator.

You will automatically have a loop created

Reference the variable in your email instead of the column.

A loop is created because the column that you are referencing can contain multiple values.

If you have mor than one column that allows for multiple values, follow the same procedure as outlined above.

Let me know if you need more help.

Was this reply helpful? Yes No
jacobmmurphy5 7 on at

Like (0)

Report
Copy link

Link copied!

Thank you Scott. I have some follow up questions.

1. Can you please refrence the attached pictures to see if I have set up the "Initialize Variable" and "Append to string Variable Correctly"?
2. I need to refrence values from two columns that are can be multiple selections choice. TO confirm: I need to duplicate this by initializing another variable and doing another "append to string variable"?
3. Are the parameters set correctly?

Thank you so much for this assistance. I know I am close to resolving this issue with your help.

Was this reply helpful? Yes No
jacobmmurphy5 7 on at

Like (0)

Report
Copy link

Link copied!

Please Disregard. I have found the solution. Thank you!

Was this reply helpful? Yes No