Showing first 20, then second 20, then third 20 results in gallery

(0) Share

Report

Posted on by andrewCardiff

First post here! I want to make printable documents from my power apps galleries to allow those people who think in paper to put something in their filing cabinets.

I've got several lists of names and phone numbers that get joined up in a gallery, and a "print" page that displays them in like our standard paper form. The form only holds 20 results, but I can't figure out how to choose to display the first 20 results of the gallery, then results 21-40, then 41-60, then 61-80, then maybe 81-94 (assuming only 94 people on the event) so that these can be printed off. I guess the first 20 is not hard, but it's the other ones that I'm stuck on..

Can anyone help?

Andrew

Categories:

Building Power Apps

All responses (1)

Answers (1)

Verified answer

iAm_ManCat 18,256 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
Hey @andrewCardiff

Yeah sure, happy to help (if you haven't figured it out on your own already since posting this last year)

We can use FirstN and LastN together to get the Xth-to-Xth records:

LastN(FirstN(colTableOfRecords, 40), 20)

I've attached a Proof of concept App you can take a look at 🙂

Cheers,

Sancho

firstlastN.msapp