web

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

News and Announcements icon

Power Platform CommunityForums Power Apps filter galery from - to

Power Apps

Answered

filter galery from - to

(0) Share

Report

Report

Posted on by Community Power Pla... Microsoft Employee

Hi Community,

I have one Gallery that is showing the information from one Entity called "Personas"

On the other hand i have one variable called FROMID with the last id of this entity

I want to put in the items formula something similar to this

Show the las 100 records from Persona starting from the variable FROMID.

In addition i will create one "pagination" where the icon next will update the variable FROMID with the last id of the gallery.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

yashag2255 24,769 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @Anonymous

Can you try to update the expressions to:

Filter(Personas, StartsWith(ID, FROMID)

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
Verified answer

v-jefferni Microsoft Employee on at

Like (0)

Report
Copy link

Link copied!
Hi @Anonymous ,

Do you want to divide the entity records to 100 per page in the gallery, and the first page to show the first 100 records?
If you do, please set the gallery screen’s OnVisible to:

Set(FROMID,Value(Last(FirstN(Sort(Personas,Value(ID),Ascending),100)).ID))

Then set the gallery’s Items:

Sort(Filter(Personas,Value(ID)<= Value( FROMID), Value(ID)> (Value(FROMID)-100)),Value(ID))

At last, to update the variable, set the OnSelect of the Next Icon to:

Set(FROMID,Value(Last(Sort(Gallery1.AllItems,Value(ID))).ID)+100)

I've made a test:
Is it like what you want?

Best regards,
Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it more.

Was this reply helpful? Yes No

Join the conversation