web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Gallery excel download...

Power Apps

Answered

Gallery excel download data

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

How to gallery check box check and un check relative data download in excel in power apps and not using power automate flow?

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Could you please share more details about your scenario? What do you mean by "download in excel"? Do you have a table in an excel spreadsheet and used as the data source in PowerApps? Does this Gallery connect to another data source where you have data that want to download to excel?

If so, you can use Patch and Remove functions OnCheck and OnUncheck properties of Check box within the Gallery to add or delete records.

OnCheck:

Patch(ExcelTable, Defaults(ExcelTable), {column1: ThisItem.columnName})

OnUncheck:

Remove(ExcelTable, LookUp(ExcelTable, columnName = ThisItem.columnName))

Best regards,

Join the conversation