cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

Retrieving multiple choice Forms Answers and Power Automate in Excel

 

I have built a Microsoft Forms survey. A few questions have multiple choice answers where the user can select multiple answers. Once the form is submitted, Power Automate adds a row into an Excel table on SharePoint. How to I get the selected answers to display in the Excel sheet? Currently, it places all the selected answers into one field.

My question is formatted as follows:
"What tasks did you complete for Q1?"
A:
B:
C:
😧

My Excel sheet is set-up as follows:

Task A Task B Task C Task D

If someone selects that they completed task a, b &c - then in Excel is places ABC in the Task A Column. I want it to break them out wherein, if A is selected place an X in the Task A column, If B is selected place X in Task B column - how can I break those apart in Power Automate?

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

Hi @shisey1,

 

You could create four condition actions to determine the answer to the question if contains the A, B, C, and D separately.

Firstly, you could create an Add a row into a table action, add some other field into it, such as user name or email.

Then create condition action check if the answer contains "A:", if yes, update a row with the task A column an "X", other 3 columns do as above:

Screenshot 2021-01-12 140411.jpg

 

Screenshot 2021-01-12 140427.jpg

 

Screenshot 2021-01-12 140443.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
Community Support
Community Support

Hi @shisey1,

 

You could create four condition actions to determine the answer to the question if contains the A, B, C, and D separately.

Firstly, you could create an Add a row into a table action, add some other field into it, such as user name or email.

Then create condition action check if the answer contains "A:", if yes, update a row with the task A column an "X", other 3 columns do as above:

Screenshot 2021-01-12 140411.jpg

 

Screenshot 2021-01-12 140427.jpg

 

Screenshot 2021-01-12 140443.jpg

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Thank you for the great suggestion. I can see how this would work, and it mostly does. It doesn't consistently get the x transferred over to the Excel sheet or in the right column, not sure why that is???

 

Also, I'm concerned that if the same e-mail responds multiple times that it won't know where to track the replies to in the Excel since the E-mail is the Key Value - any other ideas for a unique identifier?

Community Support
Community Support

Hi @shisey1,

 

1. Please notice the field name if correct when appending it into the Excel table.

2. You could consider using the GUID() function to generate a unique ID and append it to the Excel table.

 

Best Regards,
Community Support Team _ Lin Tu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

New Super Users

Meet the Power Automate Super Users!

Many congratulations to the Season 1 2021 Flownaut Crew!

Microsoft Ignite

Microsoft Power Platform: 2021 Release Wave 1 Plan

Power Platform release plan for the 2021 release wave 1 describes all new features releasing from April through September 2021.

MPA Community Blog

Power Automate Community Blog

Check out the community blog page where you can find valuable learning material from community and product team members!

Users online (81,072)