Split Multi Choice Column values

(0) Share

Report

Posted on by nmlsanmiguel

Hi Team,

NICE Day.

I would like to seek assistance regarding my export to csv values.

My multi selection column exported like this.

[{"Value":"Dacion En Pago"},{"Value":"ID"}]

I would like to ask what can I do to remove the brackets, quotations and semi colons.

I am parsing JSON upon my export and using PowerApps. Thank you!

Categories:

General topics

All responses (6)

Answers (1)

Sort by

Verified answer

CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @nmlsanmiguel ,

You can just use replace

Example would be

replace(replace(replace(replace(replace(string(outputs('Compose')), '[', ''), ']', ''), '"', ''),'}',''),'{','')

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

P.S. take a look at my blog here and like & subscribe to my YouTube Channel thanks.
Chriddle 8,729 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Assuming your array is in a Compose:

join( xpath( xml(json(concat('{"Root":{"Item":', outputs('Compose'),'}}'))), '//Value/text()' ), ',' )
nmlsanmiguel on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks your answers. But I would to know how I would reference the compose item in creation to CSV Table?
nmlsanmiguel on at

Like
a
(1)

Report
Copy link

Link copied!

I used the replace. and it worked! Thank you so much! God Bless and Merry Christmas!:)
Chriddle 8,729 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!

You take either @CFernandes or my expression, replace the outputs('Compose') with item()['<propertyName>'] and add it to the value column in you Create CSV table.

<propertyName> is the name of the property from the input (I assume it's a Select).
CFernandes 8,504 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@nmlsanmiguel @Chriddle Merry Christmas!