Downloading SP list from Power App - Choice columns coming as {"Value":"ABC"} instead of ABC

(0) Share

Report

Posted on by wonka1234

920 Super User 2024 Season 1

hi,

I am downloading my list via a button like so -

ClearCollect(TestCollection, ShowColumns('Cool Intake',"ID_three","LeadName"));
Set(varFileLink,ExporttoExcel.Run(JSON(TestCollection,JSONFormat.IgnoreBinaryData)));
Launch(varFileLink.filelink);

but i notice for choice columns I add to my ShowColumns, It comes in the onedrive excel as {"Value":"ABC"}.

Why is this?

here is my flow -

thanks.

Categories:

Building Power Apps

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

LaurensM 12,516 Moderator on at

Like (1)

Report
Copy link

Link copied!
Hi @wonka1234,

We will have to reference the .Value of that choice, which can be done by looping through our datasource and defining the column values:

ClearCollect( TestCollection, ForAll( 'Cool Intake', { ID_Three: ThisRecord.ID_three, LeadName: ThisRecord.LeadName.Value } ) ); //Set()...

If this solves your question, would you be so kind as to accept it as a solution & give it a thumbs up.

Thanks!

Was this reply helpful? Yes No