Answered

Filter rows for gallery

(0) Share

Report

Posted on by kendall1

Hi,

How would I get certain Rows from my Excel Spreadsheet to appear in my Gallery. For example, in this case I would like to extract only rows 102-104 from my Excel Spreadsheet into my PowerApps Gallery. How would I do that? Thanks.

Screenshot (76).png

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Rusk 1,369 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Is this something you want to do with a formula? For example, its ALWAYS rows 102-104 and can be coded as such. OR do you want some kind of input where the user selects what to filter?
Verified answer

v-liwei-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @kendall1

Please use this formula in the Items property of your gallery:

LastN(FirstN(TableName,104),3)

Best Regards,

Levi
kendall1 59 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Levi,

Thanks this was very helpful as a solution. Best, Kendall