Flow to split out Multiple Choice Form Answers into Separate Columns in a SharePoint List

[Anonymous]

Hello,

I have a form that will be used to request system changes and there is a multiple choice question asking which area is impacted, there are 5 specific answers to choose from plus an 'Other'

I need to be able to split these answers out into separate columns so that I can then use these answers to trigger an alert to the relevant product owner and tech lead. 

I've tried a lot of different ways of getting this to work but none of the solutions I've found seem to apply to my specific example because of the 'Other' response which could contain anything.

Is there a way to do this?

[efialttes]

Hi!

Have you already tried to convert your multichoice response into an array? You can do it by means of json() wdl function and assigning your response as its parameter... but unsure if this matches your requirements

Hope this makes sense

[Anonymous · Accepted solution]

Hey,

I did but it didn't quite work as expected (or I couldn't get it to).

What I've actually done is used an if function in compose for each option and it's given me what I need. It's not quite as dynamic as I'd intended but it does what I need it to.

Just in case anybody else is interested:

the first one is the compose named 'payroll' 

if(contains(outputs('Get_response_details')?['body/r5bea780f756e405da08519ea1377963f'],'Payroll'),'Payroll','')

I then created one respectively for each possible outcome and used the compose as the output for each of the columns in my list