Cleaning up Multiselect field

(1) Share

Report

Posted on by billf24

169

I have a form with a Choice field that a user can select multiple items.

When running Power Automate, the data comes in as "[\"Anguilla\",\"Aruba\",\"Bahamas, The\"]", and output to approval or email shows as ["Anguilla","Aruba","Bahamas, The"].

I'd like to get rid of the ["] so that just the shows as Anguilla, Aruba, Bahamas The. Sometimes though the choice field may be a single enter so no commas after the name.

Any suggestions on how to do this?

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @billf24,

Yes, in Power Automate a multi-select Choice field is often returned as a JSON array string like this.

You can use the json() function to convert it into an array, then use join() to combine the values with commas. This will give you the values in a comma-separated format

Expression:

join(json(<ChoiceField>), ', ') //<ChoiceField> - Replace with your choice field name or compos name or trigger body name

Example:

In the example below, I stored the multi select Option Set values in a Compose action and used the Compose output to display the selected values as a comma-separated list.

Ex Expression:

join(json(outputs('Compose')),',')

---------------------------------------------------------------------------

Glad it helped 🙂
If this fixed your issue, please click “Does this answer your question?” to mark it as verified so others can find the solution easily.
A Like 👍 is always appreciated, and I’m around if you need more help @Kalathiya

Was this reply helpful? Yes No
Suggested answer

11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!

The most robust solution is:

join(<multi-select-choice-array>, ', ')

which produces:

Anguilla, Aruba, Bahamas, The

and works correctly whether the user selects one value or many values.

Was this reply helpful? Yes No
Suggested answer

Valantis 6,735 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi @billf24,

Add a Compose action with this expression:

join(json(triggerBody()?['your_choice_field']), ', ')

Replace your_choice_field with the actual field name from your trigger output.

This converts the JSON array string to a clean comma-separated list: Anguilla, Aruba, Bahamas, The
Works for both single and multiple selections.

Best regards,

Valantis

✅ If this helped solve your issue, please Accept as Solution so others can find it quickly.

❤️ If it didn’t fully solve it but was still useful, please click “Yes” on “Was this reply helpful?” or leave a Like :).

🏷️ For follow-ups @Valantis.

📝 https://valantisond365.com/

💼 LinkedIn

▶️ YouTube

Was this reply helpful? Yes No