Answered

remove [ ] from output

(1) Share

Report

Posted on by NR-05111501-0

I have a MS Form that I’m using in PowerAutomate and I was wondering what I can do with the below to display the additional options without the brackets around it?
concat('TMII Configuration',
' TMII Test Capability: ',outputs('Get_response_details')?['body/rfaec6e0bffdd40d5b2bfefabde0529fd'],
' TMII Isolation Valve Required: ',outputs('Get_response_details')?['body/rc9875756ebb2463fb1194cc4bc614d4b'],
' TMII Part Evacuation Regulator Required: ',outputs('Get_response_details')?['body/raf6c8fc87bbf42c3af36e0e1d2ece592'],
' TMII # of Sources Required: ',outputs('Get_response_details')?['body/rdc0027a7148e41ea9f511e6700d4c294'],
' TMII Tooling Valves: ',outputs('Get_response_details')?['body/r8a8d0c80ffc7477dafe5145405ea7407'],
' TMII Power Cord: ',outputs('Get_response_details')?['body/r331b9f32554a4a25bf6f1a5f9230ec92'],
' TMII Additional Options: ',outputs('Get_response_details')?['body/r3642652628c144a0a27d0cc90dbcf369'],
' TMII Leak Rate & Test Pressure: ',outputs('Get_response_details')?['body/r9c6204709af745a0baaeb8901720aef0'],
' TMII Additional Notes: ',outputs('Get_response_details')?['body/rdac33cf0570047059a0087aed9753f54'])

There are 2 options available to the user but when the email producing the additional options appear as such:
TMII Additional Options: ["Hard Vacuum Gauge","Purging Clamshell"]

How do I get rid of the [“”] and only show the selected item(s)? Is there an adjustment to the code that I can add just for this situation?

Categories:

Building flows

I have the same question (0)

All responses (7)

Answers (2)

Sort by

Suggested answer

11manish 3,333 on at

Like
a
(2)

Report
Copy link

Link copied!

Use join() to convert the array into readable text

Like below :

' TMII Additional Options: ',
join(outputs('Get_response_details')?['body/r3642652628c144a0a27d0cc90dbcf369'], ', ') )

Was this reply helpful? Yes No
Suggested answer

Valantis 6,735 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @NR-05111501-0,

The brackets are showing because MS Forms returns multi-select answers as a raw JSON array totally normal but annoying to look at.

For that one field, swap this:

outputs('Get_response_details')?['body/r3642652628c144a0a27d0cc90dbcf369']
With this:
join(json(outputs('Get_response_details')?['body/r3642652628c144a0a27d0cc90dbcf369']), ', ')

That will change ["Hard Vacuum Gauge","Purging Clamshell"] to Hard Vacuum Gauge, Purging Clamshell.
One thing to be aware of — if a user only picks one option, Forms sometimes returns it as plain text instead of an array, which would break the json() part.

To be safe, use this instead:

if(startsWith(outputs('Get_response_details')?['body/r3642652628c144a0a27d0cc90dbcf369'], '['), join(json(outputs('Get_response_details')?['body/r3642652628c144a0a27d0cc90dbcf369']), ', '), outputs('Get_response_details')?['body/r3642652628c144a0a27d0cc90dbcf369'])

It checks whether the value is an array first and handles both cases. Everything else in your concat stays exactly the same.

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/

Was this reply helpful? Yes No
NR-05111501-0 43 on at

Like
a
(1)

Report
Copy link

Link copied!

Valantis-

THANK YOU SO MUCH! that worked and looks great.

Can I also use that for this same issue for a different multiple choice question

Concat is:

concat('Instrument Accessories ', outputs('Get_response_details')?['body/ra350077b3e8047bb83dce15b845b9fb8'])

produces as:

Instrument Accessories
["External Exhaust","Enhanced Fill","Diverter Valve","Remote Start/Stop Buttons","Air Filter Kit","BSPT Adapters","CTS Connects","External Leak - Staubli Tee","I/O Cable"]

Was this reply helpful? Yes No
Verified answer

Valantis 6,735 on at

Like
a
(2)

Report
Copy link

Link copied!

Hi @NR-05111501-0,

Yes you can use the same.

I am very happy that it worked out for you and i was able to help.

please Accept as Solution so others can find it quickly.

thank you and have a nice weekend.

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/

Was this reply helpful? Yes No
Verified answer

Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello @NR-05111501-0,

Yes, you can use the same structure for any other question that has a multiple-choice (multi-select) answer.

For example, using

join(outputs('Get_response_details')?['body/<your-field-id>'], ', ')

Your field ID will look something like r3642652628c144a0a27d0cc90dbcf369.

To get it, copy the question from the Get response details action in Power Automate, paste it into Notepad and extract the ID. Then replace <your-field-id> in the expression. This will turn the array into a clean, comma-separated list without brackets or quotes.

Final example like this after adding the field id:

join(outputs('Get_response_details')?['body/r3642652628c144a0a27d0cc90dbcf369'], ', ')

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

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

📩 Need more help? Just mention @Kalathiya and I’ll be happy to assist.

✔️ If this answer helped you, please tick “Does this answer your question?” so it can be marked as the Verified Answer.

💛 A Like always motivates me to keep contributing!

Was this reply helpful? Yes No
NR-05111501-0 43 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you both so much! I will get to working on this and if I have any other errors that I can't correct, I appreciate the offer to reach back out.

I really appreciate it and sorry for the delay.... I only get to work on this when I have down time and lately that hasn't come by to much :)

Have a great day!

Nora

Was this reply helpful? Yes No
NR-05111501-0 43 on at

Like
a
(1)

Report
Copy link

Link copied!

@Kalathiya

would the above join be added to my current compose with the current concat info

OR would it need to be an entirely new operation? if so, would that be added before or after my compose Accessories operation.

Please advise.

Thanks

Nora

Was this reply helpful? Yes No