Unanswered

How to ensure "Name" column of MS form is synced using Power automate

(0) Share

Report

Posted on by CU27120800-0

From the previous guide to populate new MS form response to an excel sheet,

https://support.microsoft.com/en-us/office/setting-up-an-automated-workflow-between-microsoft-forms-and-excel-through-power-automate-b59076a5-abe6-4659-8bb3-28076b3a9a7e#articleFooterSupportBridge=communityBridge

there's a step to "Map the fields from your form to the columns in your Excel table by selecting dynamic content for each column."

How to ensure the "Name" column can be mapped - since it is not a question in the form and can't be chosen.

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Nived_Nambiar 18,129 Super User 2025 Season 2 on at

Like (0)

Report

How to ensure "Name" column of MS form is synced using Power automate

Hi @CU27120800-0

Regarding the step Map the fields from your form to the columns in your Excel table by selecting dynamic content for each column.

What does it meant is you need to map the question answer to excel column where you need to get i populated. For example - assume there is a question in MS Form - what is product? and we need to populate the same in column in excel with name Product , so we select the dynamic content from get response details action which represent the question answer and add it in field corresponding to Product column. So it does not always need to have the same question title should be used as column name in excel, it is based on user requirement.

See how i have mapped the form response to this action.

Thanks & Regards,
Nived N

Stay connected:
LinkedIn | YouTube | Blogs

Was this answer helpful?
If yes, please mark it as the solution by selecting the checkbox in the discussion thread.
Your feedback motivates me to keep contributing. Thank you!

Was this reply helpful? Yes No
CU27120800-0 4 on at

Like (0)

Report

How to ensure "Name" column of MS form is synced using Power automate

Thanks Nived. In the Settings of the form, there's an option to tick "Record name" and that triggers a column - Name in the form response excel. This is a auto-generated column, same as the columns like Responders' Email and Submission time.

The Name column is not available to be mapped just like Responders' Email and Submission time

Was this reply helpful? Yes No