filter galery from - to

[Anonymous]

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.

[yashag2255]

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!

[v-jefferni · Accepted solution]

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.