Unanswered

select specific rows of record from gallery and export to excel

(0) Share

Report

Posted on by viny9889

Hello,

Is there a method to export specific rows of data from a gallery using checkboxes and then initiate a Power Automate flow with a button to export those selected records to Excel.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report
@viny9889 - this is possible but the number of steps required would be too large for a forum post. You will need to generate a Collection on the OnCheck and UnCheck properties of the Checkbox controls embedded into the Gallery with e.g.:

OnCheck:

Collect(colSelectedItems, ThisItem)

And then on the UnCheck property, use:

Remove(colSelectedItems, ThisItem)

You can then send that Collection to Power Automate using the Power Apps V2 trigger. See the example below:

https://www.youtube.com/watch?v=UZdngrwWsqA&t=1154s

Was this reply helpful? Yes No
viny9889 19 on at

Like (0)

Report

Thank you for the reply!
yes, did that with the following stesp
but kept getting

Was this reply helpful? Yes No
Ami K 15,679 Super User 2024 Season 1 on at

Like (0)

Report

@viny9889 - please raise Power Automate questions here:

https://powerusers.microsoft.com/t5/General-Power-Automate/bd-p/MPAForum

Was this reply helpful? Yes No