Power Platform Community Forum Thread Details

So before our flow broke and I got it fixed it used to send in emails in this format

Name:
Start Date: ,
End Date: ,
Type of Leave:
Total Hrs Requested:
Details:
*Important - Supervisors verify employee has sufficient leave before approving*

with the information from the form its attached to filled in.

Now it is either sending a blank email with just the approval or deny button and after tinkering around with it. I can get it to send the info by attaching the dynamic body for each response in the body but it comes out like so name(persons name),start date(the start date) and so on.

attached is a blank slate portion of the send email with options.

Thank you for any help it is greatly appreciated

Categories:

General topics

@JR45 You may find this YT Tutorial helpful: How to Get a Microsoft Form RSVP Response into a SharePoint List

Although this tutorial covers how to get the MS Form data into a SP List, the concepts covered can be applied to your flow. Simply insert the dynamic content from the form into the Body field of your action.

While building and testing your flow I would actually recommend composing the body of your email using a Compose action. Remove the Send an email with options action all together. You can quickly trigger tests and review the output of the Compose action before using it in the Send an Email action. This will speed up your flow building process so you don't need to wait for an email to arrive.

I cover the following in this video tutorial:

✅ How to get a Microsoft Form Response into SharePoint

✅ How to get a Microsoft Form ID

✅ How to get a Microsoft Form response

✅ How to Build a Microsoft Form with Conditional Fields

✅ How to used Branching in Microsoft Forms

✅ How to format Microsoft Form multiple choice responses for a SharePoint multi-choice column

✅ How to parse a Microsoft Form multiple choice response as string of text

✅ How to convert a text response to a number

✅ How to use the Switch action

✅ How to create a custom email confirmation for a Microsoft Form submission

✅ How to Create a Custom View in a SharePoint list

✅ How to use the Compose Action

✅ How to write Power Automate Expressions

Hope this helps!

If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Level up your Power Automate skills by checking out my tutorials on YouTube
👉 Tips and Tricks on TikTok and Instagram