JSON for Attachment column

(0) Share

Report

Posted on by yash_bansode

I am trying to export the data (filtered/default) from my Gallery. I tried the JSON function in the formula bar, but it says the "Attachment" column has some media and my JSON cannot convert my Attachment column into Text fields

I have tried the JSON Function of ignoring unsupported types and including/excluding binary data. Please help as to how can I export my gallery data into an excel.

I have a power automate flow saying "PowerAppExportToExcel".

In the flow, I am confused what to choose in the Inputs of the second step of "Compose"

@powerapps @PowerAutomate @microsoft

Categories:

Power Apps component framework

Power Platform Build Tools

All responses (1)

Answers (0)

v-yueyun-msft on at

Like (0)

Report
Re: JSON for Attachment column

Hi , @yash_bansode
The JSON function doesn't support all data types, and attachments is one of them (IncludeBinaryData deals with images). You can ignore the '{Attachments}' column in your collection using the IgnoreUnsupportedTypes option:
'PowerApp->Compose'.Run( JSON( MarketKVOA, JSONFormat.IncludeBinaryData & JSONFormat.IgnoreUnsupportedTypes))
Or you can Use the DropColumns() function to remove the unsupported columns first before you use the JSON() function.
And for the details steps for export the Gallery items in Power Apps using flow , you can refer to this video:
Canvas App: Export Gallery data to CSV file using Flow (youtube.com)

Best Regards,
Yueyun Zhang