I am creating a simple Power Automate Flow to generate an email when a Microsoft Form submission is made.
This all works except the "Name" field and the "Start Time" field are not available. These are automatic fields in MS Form when the Record Name setting is on. These fields are recorded in the spreadsheet attached to this Form.
Where is this Dynamic Content?
My Flow goes like this:
What am I missing?
It is interesting that the Dynamic Content lists change depending on what action block you're using.
If you use a Compose action, you should be able to access the data you want through Dynamic Content.
Then you put the output of the Compose action into your email.
you'll need one compose action block for each piece of data you need.
Other threads like this one address this issue: https://powerusers.microsoft.com/t5/Building-Flows/Microsoft-Forms-Dynamic-Content-Fields-Not-Appear...
Please let me know if this works for you!
I appreciate your response. I am a bit new to this and it is still not clear.
I have played with the Compose function, but still cannot see where I can select the missing fields from the Dynamic Data list?
What am I doing wrong?
I have not worked with Forms, and so my experience is apparently not applicable there.
I have found that the Dynamic Content lists in Compose action blocks are often more extensive than in other blocks.
Is the information that you want in the Body of the trigger output?
You can check this by running a test of the flow and going to Run history and opening that run. then expand the trigger action block (top one). There should be a block of text that makes up the trigger body. See if "Name" and "Start Time" are in there.
Forms returns the users Email address to Power Automate. You need to use the Get User Profile action and provide the action with the email address (which you have). You can select the users Display Name (and a lot of other infor) from the output of Get User Profile.
Is start time a question that you added or do you want the time that the user submitted the Form? Submission time is shown in your screen shot.
I had initially thought about "Get User Profile", but I thought you had to pass in the alpha-numeric ID of the user; I didn't realize you can use email address too.
Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.