parsing multi-select choices from MS Forms using Flow

Like (0) Share

Report

Posted on 20 Oct 2021 18:45:59 by satnam-1

Hello

I have created a Form that has a mulit-select choice response where the end-user can choose which software they would like installed on your workstation. I would like to parsing this field and extract the selected items into an email that will get sent to the helpdesk for processing.

I have looked at the other content in this forum where yes/no answers are being pulled but not sure if that applies to me but I am a novice Forms and Flow/power automate user so maybe this is a simple solution that I may have over-looked.

Thank you for your assistance!

Satnam

I have the same question (0)

All responses (7)

Answers (1)

navyjax2 98 on 27 Jun 2024 at 20:13:49

Like (0)

Report

Re: parsing multi-select choices from MS Forms using Flow

This doesn't complete everything, though. It gets to the Split, but from the Split, if you want to put the values into a multi-select Choice field on a list you need a Select, where you use the output of the Split as the "From", and you map it with "Value" (no quotes) in one box, and the current item (item()) in the other.

Then, in the "Create item" for the list, there's this little toggle on the field, itself, that changes it from receiving a textual input into an array, and you need it set to accept an array. Then you can set that field to the Output (body) of the Select: body('Select')

There's also a better way to get the input into that Split:

Initialize variable: TestMultiCheck
Type: String
Value: outputs('Get_response_details')?['body/r24aeca27c28e44a09dc8c9ec71873d18']

Compose TestMultiCheck JSON
Inputs: json(variables('TestMultiCheck'))

Join TestMultiCheck
From: outputs('Compose_TestMultiCheck_JSON')
Join with: ,

Split TestMultiCheck
Inputs: split(body('Join_TestMultiCheck'),',')

Select TestMultiCheck
From: outputs('Split_TestMultiCheck')
Map: Value
item()

Then set the list item field equal to body('Select_TestMultiCheck')

Was this reply helpful? Yes No
satnam-1 11 on 25 Oct 2021 at 19:13:36

Like (0)

Report

Re: parsing multi-select choices from MS Forms using Flow

thank you

Was this reply helpful? Yes No
AnthonyAmador 2,553 Moderator on 25 Oct 2021 at 19:10:36

Like (1)

Report

Re: parsing multi-select choices from MS Forms using Flow

It's a Compose, I just edited the name 🙂

Was this reply helpful? Yes No
satnam-1 11 on 25 Oct 2021 at 19:04:50

Like (1)

Report

Re: parsing multi-select choices from MS Forms using Flow

Hello

Just curious which Office 365 license you have as I don't see those eventhough I have an E5 license for my profile.

Thanks

Was this reply helpful? Yes No
Verified answer

AnthonyAmador 2,553 Moderator on 25 Oct 2021 at 13:57:49

Like (1)

Report
Re: parsing multi-select choices from MS Forms using Flow

I think these expressions could be useful to you

replace(replace(replace(body('Get_response_details')?['r24aeca27c28e44a09dc8c9ec71873d18'],']',''),'[',''),'"','')

split(outputs('Remove_characters'),',')

Hope this helps.
Kind regards.

Was this reply helpful? Yes No
satnam-1 11 on 22 Oct 2021 at 18:19:15

Like (0)

Report

Re: parsing multi-select choices from MS Forms using Flow

Thank you, I will have to do some more research on how to parse the output of the response data so its a bulleted List within the email body.

Was this reply helpful? Yes No
AnthonyAmador 2,553 Moderator on 21 Oct 2021 at 20:44:39

Like (0)

Report

Re: parsing multi-select choices from MS Forms using Flow

Hi @satnam-1

There is no problem extracting the answer, the only thing that you need to be keep in mind is that the answer from multi-choice option will be extracted as a string with all the responses.

For example, if you select PowerPoint and Excel the response is going to look like this ["PowerPoint","Excel"]
Here is an example.

Hope this helps.
Cheers.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No