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

Categories:

Using flows

I have the same question (0)

All responses (4)

Answers (1)

RezaDorrani 12,143 on at

Like (1)

Report

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

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
RezaDorrani 12,143 on at

Like (0)

Report

@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

Was this reply helpful? Yes No
Verified answer

v-alzhan-msft on at

Like (0)

Report

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.

Was this reply helpful? Yes No