web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

Welcome to the Power Platform Communities
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / JSON for Attachment co...
Power Apps
Unanswered

JSON for Attachment column

(0) ShareShare
ReportReport
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

yash_bansode_0-1706173961742.png

yash_bansode_1-1706174131385.png

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"

yash_bansode_2-1706174255310.png

@powerapps @PowerAutomate @microsoft 



Categories:
Power Apps Pro Dev & ISV
I have the same question (0)
  • v-yueyun-msft Profile Picture
    v-yueyun-msft Microsoft Employee on at

    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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Welcome to the Power Platform Communities

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 401 Most Valuable Professional

#2
11manish Profile Picture

11manish 201 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 128 Super User 2026 Season 2

Last 30 days Overall leaderboard

Featured topics

Auto-Populate field Power Pages
Gallery Tabs - Show or Hide Tabs based on Field Value
How to patch multiple records at once
Enable Copilot for end users in model-driven apps
Question for everyone : How are you using Create Text GPT in AI Builder?
Community content - sample components, blogs etc. - Link to this page (http://aka.ms/PCFdemos)
Welcome to the Power Apps forum!

Product updates

Microsoft Power Platform Community release plans