Unanswered

Dynamic content not showing when I want to map Excel fields to form responses

(0) Share

Report

Posted on by jude_b

I've set up a flow so that when a form is completed it adds a row to an Excel spreadsheet, but I'm not able to map the Excel fields to the form questions - when I click into the Dynamic content it doesn't show any of the form questions for me to select.

Both the form and the Excel file were created by me with the same Office 365 account - the file is saved on my One Drive. There's no connection errors showing. Is there a setting somewhere that I need to check?

I came across a post that suggested that part of the problem could be due to the 'Apply to each' setting, but I cannot stop that from appearing when I select the List of responses option in the second step of the flow...

Categories:

Building flows

Flow details.png

No Dynamic conten...

I have the same question (0)

All responses (4)

Answers (1)

creativeopinion

10,502 Super User 2025 Season 2 on at

Like (0)

Report

@jude_b The Apply to Each action isn't necessary in your flow. Pull the Get Response Details action outside of the Apply to Each action.

You might also be interested in a new YT Tutorial I recently uploaded: How to Get a Microsoft Form RSVP Response into a SharePoint List

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! If you're feeling generous— ☕️ Buy me a coffee: https://www.buymeacoffee.com/acreativeopinion

👉Watch my tutorials on YouTube
👉Tips and Tricks on TikTok

Was this reply helpful? Yes No

jude_b 6 on at

Like (0)

Report

Thanks for your advice but I cannot seem to get that to happen...
I add the Get response details action, select my form from the drop down list in the first box, then in the response ID box the only option I have from the Dynamic content is 'List of response notifications Response ID. Once I select that then the whole action is automatically enclosed within the Apply to each box - and when I try and drag the action back out I get an error message - 'This action cannot be dragged out of foreach as it depends on an action inside foreach.'

Is there something amiss with the way that my organisation has set up our accounts?

Was this reply helpful? Yes No
Verified answer

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@jude_b If you started editing your flow in the new designer, you may need to create a new flow and switch to the Classic Designer first before you start editing. This seems to be a bug with the new designer.

Was this reply helpful? Yes No
jude_b 6 on at

Like (0)

Report

Thank you so much! I have been trying to figure out where I was going wrong for days! (On and off anyway.) Just created a new flow completely from scratch with the new designer turned off and the fields were there - huzzah!

Was this reply helpful? Yes No