
Announcements
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.
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!