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?"
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?