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

In this video, you will learn how to create pagination gallery in power apps.
Also, Count Rows is a non-delegable function. In this video, I have covered how to handle delegation warnings.
Code Used:
Screen on Visible:
Set(vrPageNumber,1);
Set(ItemCount,'PowerAppV2-SendanHTTPrequesttoSharePoint'.Run("Database").result);//countrows is not a delegable function
Gallery Items:
If( vrPageNumber = 1, FirstN( Database, dd_pagesize.SelectedText.Value * vrPageNumber ), LastN( FirstN( Database, dd_pagesize.SelectedText.Value * vrPageNumber ), dd_pagesize.SelectedText.Value * 1 ))
Back Button:
Set(vrPageNumber,vrPageNumber-1)
Next Button:
Set(vrPageNumber,vrPageNumber+1)
Label:
vrPageNumber & " of " & RoundUp(ItemCount/dd_pagesize.SelectedText.Value,0)
PowerAutomate Flow:
/_api/web/lists/getbytitle(‘listtitle')/?select=ItemCount
----------------------------------------------------------------------------------------------------------------------
Follow me on Twitter to get Office 365 updates:
Twitter:
/ sagarsharma94​
Gmail: [e-mail]
Facebook:
Join the Facebook group to collaborate with SharePoint Community
/ 52910​. .
---------------------------------------------------------------------------------------------------------------------------
Like, Share, and Subscribe to our channel for more informative and development-related videos. Much Love! Keep Learning! :)

[@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?

[@user-pb8lm1jy8o]

how to write search function along with pagination

[@user-cd8ee1bn7o]

How to get the Parse JSON schema value?

[@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
.

[@siddheshahire9632]

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

[@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.

[@DavidAdediran]

Have you tried to page to 1466?

[@ranatahirtahir9980]

Awesome 👍

[@dstechmirror1396]

Thanks 🤗

[@elisatrifiro6099]

thanks a lot for this video

[@dstechmirror1396]

Welcome!

[@kireetiyakkali]

This approach doesn't support delegation 😢

[@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
)

[@user-ln2lj4yn5k]

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 ?