Unanswered

Remove characters from Forms multiple answer response

(0) Share

Report

Posted on by Mike44

266

I built a fairly simple flow that collect responses from an MS Form and adds them to an Excel spreadsheet. Two of the questions are multiple answer responses which could display in Excel as: ["HPC","Non-Medical","Nursing"] depending on what was selected on the form (i.e., results could more or less). I would like the end result in Excel to look like: HPC, Non-Medical, Nursing (i.e., removing the brackets and quotation marks) Note: comma follows each word with a space. Below is a copy of my flow. The two responses are Services Offered and Waiver Type(s).

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

creativeopinion 10,502 Super User 2025 Season 2 on at

Like (0)

Report

@Mike44 You need to use an expression with the json() function for your multi-choice question.

Then you can use a Select action and a Join action to output the selections separated by a comma.

In the From field of the Select action, insert the outputs from the Compose action. Use the item() function in the Map field.
In the Join action, insert the outputs from the Select action. In the Join with field, insert your separator (in your case a comma and a space)

Hope this helps!
If I helped you solve your problem—please mark my post as a solution ✅.
Consider giving me a 👍 if you liked my response!

👉 Watch my tutorials on YouTube
👉 Tips and Tricks on TikTok

Was this reply helpful? Yes No
Mike44 266 on at

Like (0)

Report

I only have one word- AWESOME! Thanks, worked perfectly.

Was this reply helpful? Yes No