Answered

MultiSelect Form Flow to Separate Excel Column

(0) Share

Report

Posted on by Community Power Pla...

I am creating a form for daily reports, I would like to have a select all that apply list for the reasons behind downtime. The issue I am having is once I build a flow to excel all options show up in a json string, I would rather these appear in multiple columns so when creating BI reports I can create graphics for each selection- not the specific string. Also, when the flow emails a daily report, I would like the selctions to be in a list, without the extra characters.

Email: email help.PNG

All responses (4)

Answers (1)

Verified answer

v-alzhan-msft on at

Like (0)

Report

Re: MultiSelect Form Flow to Separate Excel Column

Hi @Anonymous ,

Does you want the multiselect answer in flow could be as weather,dryer,motor equipment directly without “” ?

If yes, please refer to link below to see if your problem could be solved:

https://powerusers.microsoft.com/t5/Building-Flows/When-using-the-answer-from-a-multiple-choice-question-on-a-Form/td-p/169975

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
RezaDorrani 12,141 on at

Like (0)

Report

Re: MultiSelect Form Flow to Separate Excel Column

@Anonymous

Your use case stated you rather have them in multiple columns rather than single column in excel

so before putting into excel you can perform the split operations get the data and then accordingly populate them in your excel columns
Community Power Pla... on at

Like (0)

Report

Re: MultiSelect Form Flow to Separate Excel Column

@RezaDorrani

Are you saying use a split equation to seperate these once they are in excel to send to multiple columns? I know I can do the text to columns, but that does not apply to new rows once a form is submitted.
RezaDorrani 12,141 on at

Like (1)

Report

Re: MultiSelect Form Flow to Separate Excel Column

Hi @Anonymous

The following expression will give you comma seperated values of the choices returned from the MS Form selections
replace(replace(replace(dynamiccontentfieldinform,'["',''),'"]',''),'","',',')

In order to get an array
you can then use the split function to get array from above expression
split(outputofaboveexpression, ',')
this will give you an array of the values selected in MS Form

Regards,
Reza Dorrani

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