Limit of rows in Power apps to Power List

[Evbelda]

I have a Power list having more than 2000 rows. I saw connector of power apps that is a limit of 2000 row bring to the APP.

It is posible to filter conections not at the start of APP, but when I'm doing filters reconect with the filter in runtime app?

Any solution to bring more than 2000 rows from a power list?

[AmDev]

Hi @Evbelda 

Are you referring to a SharePoint List? - There are ways in which you can query your >2000 dataset without coming up against delegation issues (the 2000 limit you mentioned)

Can you clarify if this is what you are referring to?

[Evbelda]

Yes , I was referring to SharePint List. You can create a connection to a SharePoint List. In the configuration of Power apps, there is a section telling: "Limit of data file". In the text seems to refer of connection limit (in this case to the conection of a sharepoint list).  

Or, how can I get from a power list with more than 2000 rows, 20 fields per row filtered and put it on a Gallery, for example?

[RandyHayes]

@Evbelda 

You can never retrieve more than 2000 records in PowerApps.  It is just not possible.  Your list can have much more than 2000 and you can pull chunks of 2000 records at a time to populate the internal memory of your app.  So, you can certainly HAVE more than 2000 records in your app, but you can never PULL more than 2000 records at a time.

That said, are you actually having an issue with delegation?  Is there something you are trying that is not delegable?  If so there are a lot of ways around it depending on the requirement.

However, consider the user perspective - is more than 2000 records really relevant?  Will the user actually be looking at 2000 records in the app?

Also...a little known aspect of PowerApps - a Gallery is capable of getting over 2000 records.  It will not get them all at one time, but instead it will get it as the user scrolls through the gallery.  When they near the bottom of the Gallery, PowerApps will go to the datasource to gather more records.  It will continue to do this past any 2000 record limit.  However, for this feature to work, it is highly dependent on the formula in the Items property of your Gallery.

I hope this is helpful for you.

[Evbelda]

Thanks for all your answers,

As you said @RandyHayes, there is not necesary to PULL more than 2000 records. The way is to PULL less than 2000 records, but pull it exactly the records you want from the original list.

As I could see, I couldn't  make an specific pull to a connection of a list (you connect to a list with no parameters), and you can't refresh the connection to bring others "less than" 2000 records.

The only way I found was thougth a flow (automate Flow.Run()) but the problem is to bring "easily" the JSON returned with 20 fields every record into a Collection to get it on a Gallery. Regular Expressions for a JSON text retuned from a flow are not an easy expresions Match, due to the amount of extra information you bring in a flow JSON.

There are any other possibility?

I will apreciate other posibilities

[Evbelda · Accepted solution]

Hello,

After all I could get a solution to this proble (get an amount of rows in a Gallery not using a conection that can get no more than 2000 records)

It was with a flow to PowerApps, you can make the filters you want sending a flow with the specific parameters, and get  the specific records to load in the Gallery)

This is the method:

Solved: Response an instance of Power apps from Power Auto... - Power Platform Community (microsoft....

I hope this could help to the comunity

[Diederik_H]

Hi Randy,

Thanks for your reply.
I am having problems with the max amount of 2k rows:
I am trying to group data with a GroupBy function. (several rows are a list together). This happens after applying a filter to the DataVerse source (that has >2k rows). less than 2k is pulled.
The problem is that the grouped list itself excludes some of the rows which should be present in the filtered data. I am not pulling 2k rows as all, but it is still excluding rows of the pulled data. What is going wrong here?

thanks in advance for your time.

[Evbelda]

Hi,

First of all the problem is de conection you are using. If you are using a PowerApps conection to retrieve the dataverse data, that means you have 2k records of maximun retrieve.

That is, If you have more than 2k and after that you use a filter you are not pulling all the rows you want, only the first 2k rows.

So the filter is not applied over the rows you want,

So, the solution is using PowerAutomate. A problem is that you need to use a premium block to do that, but this premium block is admited by now. 

[Diederik_H]

Thanks for your reply,
Yes, I am using the PowerApps connector. So if I understand correctly:
Even if I use the connector, using Filter(source, x=y) which should give <2k rows, it will still exclude rows, as it filters áfter extracting the maximum of 2k rows?

kind regards,

Diederik

[Evbelda]

Exactly. You need to do the filter in Power Automate and retrieve the rows you filtered through Power Automate to Power Apps