In this blog post, I will walk through the steps you can follow to increase the number of records to be shown by default in the add record subgrid where a user can select records to be associated.
Problem Statement
How to increase number of record to display in Power Apps Portals? How to remove pagination from subgrid in Power Apps portals? How to change default 10 records limit in Power Apps Portals?
Solution
To edit the maximum number of records that are displayed on a single page inside subgrid, you can add a "Site Settings" record. After the changes are done, make sure that you have cleared out the cache so that the changes are reflected.
How to add Site Settings?
1) Open the Portal Management App, and select "Site Settings" from the sitemap.
2) Select New from the top navigation to add a new Site Setting.
3) Add the below information to the form as
Name : Portal/Lookup/Modal/Grid/PageSize
Website : Select the Portal Website record.
Value : 100 (Number of rows that should be displayed in the grid).
Note: If you want to remove pagination, add Value greater than the number of records that exist.
4) Clear the cache so that the changes are reflected.
DEMO
In this post we saw how to edit the pagination properties of a subgrid in Power Apps Portals. This allows users to see the records on one page as a on-going list rather than have to change the pages every time.
I hope this was useful for you. In case of any questions or suggestions, feel free to reach me out on twitter at @agarwal_ritika.
Comments