Forum Discussion
Brad_Berkobien
Jan 30, 2023Copper Contributor
Sharepoint Pagination not working
Hello, I am using Sharepoint online for365 the dev account. This is also happening to others trying to implement our REST API. I see a "Show Paging" Check box but that doesn't seem to do anything....
Adnan_Amin
Jan 31, 2023MVP
If you are using SharePoint Online, you can limit the number of items displayed in a REST API call using the "$top" query parameter. The "$top" parameter specifies the number of items to return in the response. For example, to return only the first 10 items from a list, you can add "$top=10" to the end of the API URL.
For example:
https://<site_url>/_api/web/lists/getbytitle('<list_name>')/items?$top=10
To implement paging, you can combine the "$top" parameter with the "$skip" parameter, which specifies the number of items to skip before returning results. For example, to return items 11-20 from a list, you can use the following API URL:
https://<site_url>/_api/web/lists/getbytitle('<list_name>')/items?$top=10&$skip=10
You can use these parameters in your REST API call to limit the number of items displayed and implement paging in your Power Apps form.
- Brad_BerkobienJan 31, 2023Copper Contributor
Adnan_Amin Thank you for your answer. Is there anyway to show the paging buttons at the bottom