Answered

MS Forms multiple choice answers to SharePoint list

(0) Share

Report

Posted on by oslopez28

Hi Everyone,

I'm hoping I can get some help with a Flow that I'm working. I have a Form that has some multiple-choice questions. The answers are used to create a new SharePoint item. Unfortunately, the format of the data entered into the list is not good.

Here's what winds up on the list:

If someone selects are choice options:

["ISJ 1st Floor Zone 1 (Shipping / Labs / TDK Ventures)","ISJ 1st Floor Zone 2 (Labs on the Parking Garage Side)","ISJ 1st Floor Zone 3 (Future technolobby)","ISJ 2nd Floor","ISJ 3rd Floor","ISJ 4th Floor","ISJ 8th Floor","IBK "]

If someone selects just a few choice items:

["ISJ 1st Floor Zone 2 (Labs on the Parking Garage Side)","ISJ 2nd Floor","ISJ 3rd Floor","ISJ 4th Floor"]

Ideally, I'll like the format to look like this (depending on the answers selected):

ISJ 1st Floor Zone 2 (Labs on the Parking Garage Side)

ISJ 2nd Floor

ISJ 3rd Floor

ISJ 4th Floor

Here's what my flow looks like:

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

oslopez28 21 on at

Like (0)

Report

One more thing!

I tried this solution, but it makes every SharePoint list entry the same, regardless of what was selected in the Form. The format of the text however is just like i need it.

The compose 2 is set as such: join(outputs('Compose'), decodeUriComponent('%0A'))

Was this reply helpful? Yes No
HenWang Microsoft Employee on at

Like (0)

Report

Hi @oslopez28 ,

I think you are almost there and the expression you are using is correct. Please remove the content inside your Compose action and replace them with the dynamic content related to this specific choice column from your Microsoft form. This will help to dynamically create the item according to user's own selection.

Hope this can help.

Best Regards,
Hen Wang

Was this reply helpful? Yes No
Verified answer

HenWang Microsoft Employee on at

Like (0)

Report
Hi @oslopez28 ,

After testing from my side, I found that when I select the choice column dynamic content in compose action, flow can only recognize it as string value instead of array value, which is not valid for the join expression in following step:

Just in case you have the same scenario, please feel free to refer to my below solution, maybe stupid but it does work for me:

Whole flow:

1.Need to initialize an array variable named "Choice_response"

2.In my Compose 3 action, I used below expression, I think you can directly copy and paste:
split(replace(replace(replace(outputs('Compose'),'[',''),']',''),'"',''),',')

3.Create an "Apply to each" action manually: Please select the outputs dynamic content from the previous step, which is the Compose 3 action in my flow.

4. append to array inside the loop:
The value is using expression :
Item()

5. the final join expression:

join(variables('Choice_response'), decodeUriComponent('%0A'))

Hope this can help.

Best Regards,
Hen Wang

Was this reply helpful? Yes No