Skip to main content

Notifications

Power Automate - Using Connectors
Answered

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

(0) ShareShare
ReportReport
Posted on by 7

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?

 

jacobmmurphy5_0-1703248309959.png

 

 

  • jacobmmurphy5 Profile Picture
    jacobmmurphy5 7 on at
    Re: Generate Email from New Sharepoint Item - Email Contains Sharepoint Choice Data

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

  • jacobmmurphy5 Profile Picture
    jacobmmurphy5 7 on at
    Re: Generate Email from New Sharepoint Item - Email Contains Sharepoint Choice Data

    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.

     

    jacobmmurphy5_0-1703262532985.pngjacobmmurphy5_1-1703262557242.png

    jacobmmurphy5_2-1703262704433.png

     

  • Verified answer
    ScottShearer Profile Picture
    ScottShearer 25,150 on at
    Re: Generate Email from New Sharepoint Item - Email Contains Sharepoint Choice Data

    @jacobmmurphy5 

    Try this:

    1. Before the Send an email action, initialize a string variable
    2. Add an "Append to a string variable" action
    3. Select the column that is causing the loop followed by a comma and a space so there is a separator.
    4. You will automatically have a loop created
    5. 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.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,495

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,822

Leaderboard

Featured topics