Skip to main content

Notifications

Announcements

Announcing our 2025 Season 1 Super Users!
Welcome to the Power Platform Communities
Join us for the Powerful Devs Hack Together
Announcing Forum Attachment Improvements!
News and Announcements icon
Power Platform Community / Forums / Power Automate - Building Flows / Workflow MS Forms - Excel
Power Automate - Building Flows
Suggested answer

Workflow MS Forms - Excel

(1) ShareShare
ReportReport
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:
Business Process Flows
  • trice602 Profile Picture
    trice602 11,643 on at
    Workflow MS Forms - Excel
    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

  • Suggested answer
    trice602 Profile Picture
    trice602 11,643 on at
    Workflow MS Forms - Excel
    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing our 2025 Season 1 Super Users!
Welcome to the Power Platform Communities
Join us for the Powerful Devs Hack Together
Announcing Forum Attachment Improvements!

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,434

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,722

Leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans