• Ritika Agarwal

Remove Pagination from Associated Subgrids in Power Apps Portals

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.

Get All the New Posts to Your Inbox
© 2020. Ritika Agarwal
  • LinkedIn
  • Twitter