Unanswered

Choice Columns in JSON Output

(0) Share

Report

Posted on by sperry1625

765 Super User 2024 Season 1

I am converting data entered by a user in a SharePoint list to JSON and passing it to a Power Automate Flow to create a CSV file that I the user downloads. The process works perfectly. The issue I am having is with Choice columns. A Choice column shows in the CSV as follows:

Single Select Choice: { "Value":"Choice Value"}
Multi Select Choice: [{ "Value":"Choice Value 1"}, {"Value":"Choice Value 2"}]

My preference would to have the columns contain a quoted list, like below.

Single Select Choice: "Choice Value"
Multi Select Choice: "Choice Value 1, Choice Value 2"

What is the best way to accomplish this? Do this in the Power App? Do this in the flow. The data being downloaded to the CSV is multiple records, if that matters. There are several columns within the out put that would need to be "Cleaned" before putting in the CSV file.

Any guidance/best practices would be appreciated.

Thank you.

Steven

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Sort by

emfuentes27 578 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello @sperry1625 . Any update on this? I'm having the exact problem. Thanks.

Was this reply helpful? Yes No
emfuentes27 578 on at

Like
a
(0)

Report
Copy link

Link copied!

Got it. AddColumns will do.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi my current code on my powerapps onselect is "ForAll(Gallery8_5.AllItems,Collect(colGalCSV,{ MagazineID: ThisRecord.'Magazine ID', MaintenanceType: ThisRecord.MaintenanceType.Value, Replacement: ThisRecord.Replacement.Value, Date: ThisRecord.Date})); Set(varFileLink,Trial.Run(JSON(colGalCSV,JSONFormat.IncludeBinaryData&JSONFormat.IgnoreUnsupportedTypes)).filelink);Launch(varFileLink);Clear(colGalCSV)" and my value return in csv for maintenance type and replacement is "[{"Value":"Wet Cleaning"},{"Value":"Part Replacement"},{"Value":"Allignment"}]" & "[{"Value":"Top Panel"},{"Value":"Rear Panel"},{"Value":"Front Panel Screw"},{"Value":"Acrylic Holder"},{"Value":"Top Panel Screw"},{"Value":"Bottom Panel"},{"Value":"Bottom Panel Screw"},{"Value":"Front Panel"}]" respectively. How do I only acquire the value like this "Wet Cleaning, Part Replacement"

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi any update on this?

My current code on my powerapps onselect is "ForAll(Gallery8_5.AllItems,Collect(colGalCSV,{ MagazineID: ThisRecord.'Magazine ID', MaintenanceType: ThisRecord.MaintenanceType.Value, Replacement: ThisRecord.Replacement.Value, Date: ThisRecord.Date})); Set(varFileLink,Trial.Run(JSON(colGalCSV,JSONFormat.IncludeBinaryData&JSONFormat.IgnoreUnsupportedTypes)).filelink);Launch(varFileLink);Clear(colGalCSV)" and my value return in csv for maintenance type and replacement is "[{"Value":"Wet Cleaning"},{"Value":"Part Replacement"},{"Value":"Allignment"}]" & "[{"Value":"Top Panel"},{"Value":"Rear Panel"},{"Value":"Front Panel Screw"},{"Value":"Acrylic Holder"},{"Value":"Top Panel Screw"},{"Value":"Bottom Panel"},{"Value":"Bottom Panel Screw"},{"Value":"Front Panel"}]" respectively. How do I only acquire the value like this "Wet Cleaning, Part Replacement"

Was this reply helpful? Yes No