How to Create Pagination Gallery in Power Apps when Connected with large SharePoint List

[@dominicgraytechnology]

Thanks for providing the code in the video description - very helpful. It appears that folk may need delegation assistance (ie powerautomate workaround) to fetch rows beyond the delegable limit

[@vandanpandya9587]

In Microsoft documentation, firstn, lastn are non-delegable. How is it working then? Can you please explain?

[@saranchowdarymanchina3407]

Hi i just created power automate flow to get the SQL table items count . for count it's working fine but not able to show the data more than 2000 items.could you please help on this.Thanks

[@Sudhan369]

How to get the Parse JSON schema value?

[@siddheshahire9632]

what to do if want to use dataverse instead of sharepoint list or excel instead sp list

[@barbodvarjavandi9228]

Hi,
Thanks for the video which is very helpful.
Question: instead of getting the count of the entire table, How do I pass a Filter to the flow?
Thanks in advance
.

[@ranatahirtahir9980]

Awesome 👍

[@dstechmirror1396]

Thanks 🤗

[@FireFist217]

"test" option is not available until the schema is filled and the flow is complete .
we don't have the schema to complete the flow
you are copying the body from a completed flow
how to get the schema if we can't run the flow

[@himavanthJarugumalli]

how to write search function along with pagination

[@adedaporh]

Have you tried to page to 1466?

[@SathyaKrishna143]

Can you please go to 1466 Next(Right) Button is till working after reaching the last record
can you slove it like the left button is disbaled

[@barbodvarjavandi9228]

in DisplayMode of the right arrow put:
If(varPage=RoundUp(VarNumberOfRecords/ddNumRowsPerPage.Selected.Value,0),DisplayMode.Disabled,DisplayMode.Edit)
and in the items put the following for LastN
If (
ddNumRowsPerPage.Selected.Value * varPage > VarNumberOfRecords,
VarNumberOfRecords - ( ddNumRowsPerPage.Selected.Value * (varPage - 1)),
ddNumRowsPerPage.Selected.Value
)

[@elisatrifiro6099]

thanks a lot for this video

[@dstechmirror1396]

Welcome!

[@SanjayKumar-go3nl]

It is really nice videos; however, it is only giving 2000 max record as FirstN and LastN is not delegated function. Does anyone know how to resolve.

[@phanikumar-u7f]

Hi Bro, after 500 items pagination is not working, same steps i did, can you please suggest..

[@sssss9680]

Even I am facing same , is there any fix on this issue ?

[@kireetiyakkali]

This approach doesn't support delegation 😢