Unanswered

Splitting Multiple-Choice Outputs

(0) Share

Report

Posted on by irocha

Hey Power Automate Team,

I have a form that outputs data into my Sharepoint list via a flow. There is a section in the form for multiple-choice answers; however, they are displayed in a single line. I want them to be separated to display individually.

Screen Shot 2022-07-13 at 3.30.17 PM.png

it's showing up like this ^ but I want them to be shown individually in new lines (like a simple list format)

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (0)

Sort by

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@irocha you can refer to this post in order to update multichoice column value https://powerusers.microsoft.com/t5/Building-Flows/Update-item-with-multiple-choice-columns/td-p/425901

Let me know if you run into issues implementing it.

Was this reply helpful? Yes No
irocha 32 on at

Like (0)

Report
Copy link

Link copied!

@annajhaveri thank you for providing this resource; however, this does not solve my current problem with the running string.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
@irocha try following solution, it should work, as i have already tested it:

1. Add compose action with following expressions, here in the expression first replace outputs('Get_response_details')?['body/r11e08973b90a4c588aeaa2a4ebe1be37'] with your form checkbox output dynamic content.

split(outputs('Get_response_details')?['body/r11e08973b90a4c588aeaa2a4ebe1be37'],',')

2. Add Initialize Variable action of type Array and name as ChoiceValues

3. Add Apply to each action and select output from the Compose action which we added in step 1

4. Inside apply to each action, add Compose action with following expression:

replace(replace(replace(items('Apply_to_each'),'"',''),'[',''),']','')

5. Under compose action add Append to array variable action and configure it as shown in below screenshot, here you will use output of compose action added in step 4

6. After apply to each action, outside of it, add Update Item action and select the ChoiceValues variable for dynamic content of your Choice column in SharePoint list

Here is the full flow screenshot

Was this reply helpful? Yes No
irocha 32 on at

Like (0)

Report
Copy link

Link copied!

@annajhaveri thank you for taking the time to complete this flow. I appreciate it; however, something is still going wrong. I duplicated your flow, but the 'ChoiceValues' never came up as an option to insert in my SharePoint
list, and I also had an error.

Was this reply helpful? Yes No
v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!

Hi @irocha ,

You did not apply the same sequence of actions as the flow in the screenshot. The "Get response details" action should be just below the trigger, then under this action are the actions from in the screenshot.

Best regards,

Was this reply helpful? Yes No
irocha 32 on at

Like (0)

Report
Copy link

Link copied!

@v-jefferni @annajhaveri I created a new flow to try and copy the sample from above, and it was all falling into place until I reached the 'Update item action. It didn't give me the option to add the ChoiceValues in the chose column section.

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@irocha you mean you are not getting ChoiceValues in Update Item dynamic content? try using the expression variables('ChoiceValues')

Was this reply helpful? Yes No
irocha 32 on at

Like (0)

Report
Copy link

Link copied!

Hey @annajhaveri
It still didn't work after I inserted the expression you suggested for 'ChoiceValues'

The output now looks like this:

Was this reply helpful? Yes No
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@irocha are you getting any error, can you share the screenshot of it please?

Was this reply helpful? Yes No
irocha 32 on at

Like (0)

Report
Copy link

Link copied!

@annajhaveri It does have an error in the 'Update item' action. It reports back that it can't find my list. The other flow I worked on that is updating my SharePoint list is connecting to it just fine, but with the new action of 'Update item,' it asks for an additional input: 'Id' here; I put the Response Id. Is there something else I should be putting here?

Was this reply helpful? Yes No