Unanswered

How to Separate Multi-Answer Responses From a Form When Its Uploaded to a SharePoint List

(0) Share

Report

Posted on by CC-14031628-0

Hello,

I have been trying to get my SharePoint list to show the multi-answer questions separate for easy viewing but I cannot figure it out.

So a bit of background. I have created a form for work and I have created a Power flow to upload the responses to a list on a SharePoint site. However, when it comes to uploading the multi-selection answers it just puts them into a long bauble as you can see in the image below?

How can I get it to separate them so they show in the same way as the coloured ones?

For example, the question in my form has multiple choice but you can only select one, this works as it shows in the blue or red baubles.

But say for the equipment, I need to know what they need so it can be more than one thing, I have already set up in the list those choices but I just want it so show singerly if that is possible.

Thanks,

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Michael E. Gernaey 53,335 Super User 2025 Season 2 on at

Like (0)

Report

Hi @CC-14031628-0

How is the form data uploaded to SharePoint?

If it were power automate I would do the following

split(replace(replace(FormAnswer, ']"' , ''), '"[', ''), ',')

Where it will first replace the ]" and an empty space

Then it replaces "[ with an empty space

Then it splits the remaining by a ,

which gives you 3 separate things

However, in Sharepoint, is this a Multiline text field or a single?

Was this reply helpful? Yes No
CC-14031628-0 2 on at

Like (0)

Report

Hello,

@Michael E. Gernaey

Thanks for replying. I am a bit new to using Power Automate but from following Co-Pilot I managed to create this:

So it does work for what I wanted, but like the first image, I just want the multi-selections to be separated and colourful like the column in OPS Only, as you can see in the image.

Can you explain where I can put the split(replace(replace(FormAnswer, ']"' , ''), '"[', ''), ',') ?

What would FormAnswer be replaced by? can that be a dynamic?

"However, in Sharepoint, is this a Multiline text field or a single?"

In the Sharepoint the answer I have made that column "Choice"

In the form I have about 6 multiple choice questions.

Was this reply helpful? Yes No