Workflow MS Forms - Excel

(1) Share

Report

Posted on by JR-16011310-0

Hello everybody,

i have created a workflow in which data from a MS Forms survey is transferred to Excel. I was able to read all the answers and have them transferred. What I could not read out so far was the name of the submitter and the language which is selectable as a dropdown. How can i select this information?

I also have the problem that selection fields from the Forms are output in " " in Excel. How can I remove these in the Excel?

Thank you very much.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (0)

Suggested answer

trice602 16,023 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

In Forms you have two choices (for this issue). If your submitter is an internal employee, you don't have to ask them who they are because you can automatically get that with the action. Get response details.

In Get response details action, the dynamic content will be listed here.

Now, if your submitter is not an internal employee, aka this is a public form and anyone with the link can submit, you have to ask the question, "enter your email address" because public forms don't capture who is submitting without asking.

In addition, if the language is a dropdown question, it will also appear as dynamic content in the Get response details shown above,

------------------------------------------------

⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
trice602 16,023 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

One last comment: Your values from Microsoft Forms will always be string values. So as you are writing a numeric value to Excel, you will wrap it in an INT() expression.

------------------------------------------------

⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
trice602 16,023 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hey there!

I am following up on this post workflow ms forms - excel in this category building flows from 01/16/2025. I know the post is a little older, but it is a common question here so wanted to take a moment and follow-up. I see there have been 2 replies and 1 likes and asking if your question has been answered. If so, please help the community out by completing one or more of the following actions! Thanks in advance!

Easy as 1-2-3 ‼️💯⭐😎🆒🙏

1) Mark a reply as a verified answer - this is essential, and it helps others with the same general question find this thread. ✅

2) You can also mark one of more replies as a verified answer. Please take a moment and give the author credit for volunteering their time. ✌️

3) Like one or more replies. Kudos always greatly appreciated! 👍

Pro tip: if you found your own solution or workaround, feel free to add a reply to your own post and mark it as the solution too! The goal is to get this thread marked with a verified answer by anyone that finds one or more replies helpful!

Again, thanks in advance for reading and responding, always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No
trice602 16,023 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

If I can help with anything else please let me know or tag me in a future post, I enjoy reading and answering questions. Always glad to help! Tom 💯💯💯💯💯

Was this reply helpful? Yes No