How to Overcome 500 item limit in PowerApps | Tips and tricks

By default, the search button does not work if you want to search in multiple columns. That is another limitation to this entire gallery is that it can only search up to 500 rows. That's one of the limitations of the gallery. There is a workaround for that.

The first step that you need to do is go to File, then go to Settings, then scroll down to the bottom. As you can see over here, the data rule limit is set to 500. What you can do is you can increase this limit up to 2000. Even if you try to increase further it will say that it needs to be below 2000. So this is the first thing that you can do. So set the data roll limit up to 2000. Once you have done that, you can close this. 

The second thing that we need to do is we need to change the search criteria for the Browse gallery. So once you click on that, paste this command in the items under the Items section. So what we are doing is we are basically filtering the data from the source which is our inventory which is a SharePoint list. What we're using is via utilizing an amazing function which is called the starts with this is a lifesaver. And we what we are doing is in my case, I have deck one, that's the assigned to section in my SharePoint list. And the title is the model number of and so what I'm doing is I'm searching multiple columns I'm also searching the assigned to and also searching the title and if you want you can add even the third option as well by adding by just adding the starts with again. So over here we are utilizing the OR function and once you do this way you will be able to search as many records as possible through delegation. And we are utilizing the starts with function over here. And that's how you overcome the 500 row limit.

Official Doc from Microsoft:

Below is the Real-Life Business Solutions Series Playlist:

Microsoft 365 Business Standard:
Microsoft 365 Apps for Business:
Microsoft 365 Business Premium:
Microsoft 365 Personal:
Microsoft 365 Family:
My Favorite Youtube SEO Tool:
⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.


Popular posts from this blog

How to create Easy Data Entry Forms in Excel

Build an inventory management app using Microsoft Powerapps

Build Site Inspection App | PowerApps