web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Remove characters from Forms multiple answer response

(0) ShareShare
ReportReport
Posted on by 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). 

1.png2.png

I have the same question (0)
  • Verified answer
    creativeopinion Profile Picture
    10,480 Super User 2025 Season 2 on at
    Re: Remove characters from Forms multiple answer response

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

     

    creativeopinion_1-1696353970889.png

     

     

    creativeopinion_0-1696353944029.png

     

    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.

    creativeopinion_3-1696354024200.png

    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)

    creativeopinion_4-1696354046279.png

     

    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

     

     

     

     

  • Mike44 Profile Picture
    266 on at
    Re: Remove characters from Forms multiple answer response

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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 788 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 452 Moderator

#3
developerAJ Profile Picture

developerAJ 302

Last 30 days Overall leaderboard