Unanswered

Question for limitation

(0) Share

Report

Posted on by Lisa

hi,

is there any limitation when searching source data? such as filter, search, lookup, count and etc... and also Is there any limitation when using DataTable?
I've already check 'understand delegation' link but cannot understand whole of thing.

Thank you

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Meneghino 6,949 on at

Like (0)

Report

Hi @Lisa, basically if all of your tables have <= 500 rows and you are not worried about optimising performance/speed then there are no limitations.
If any of your tables have more than 500 rows then you really need to understand delegation. The details are different for different data sources. What is your data source?

Was this reply helpful? Yes No
danbi1991 Microsoft Employee on at

Like (0)

Report

Hi @Meneghino, Thank you for your kind answer.
My data source is excel and sql database and my table has more than 500 rows.
I'd like to know the exact limitation when doing something (search, count, filter and etc) in PowerApps.

Thank you

(I am Lisa and I logged in another account.)

Was this reply helpful? Yes No
Meneghino 6,949 on at

Like (0)

Report

Hi @danbi1991
Again, the details are very different depending on the data source. Excel has no delegation at all (and I would not recommend using it as a data source in PowerApps) whereas there is quite a bit of delegation in SQL Server / Azure SQL Database.
The details of the exact limitations are described here:
https://powerapps.microsoft.com/en-us/tutorials/delegation-list/

From this you can see that Excel is 'coming soon', which means that you can only see the first 500 rows of any table for any function for the moment. But again, I would never use Excel if you can use an SQL database.

As you can see, for SQL DB you can Search and Filter (depending on operators used) all rows of any table, but Count is limited to the first 500 records for the moment. However, if you first filter then you can count up to 500 rows over all the table.

It might be easier if you tell me what it is you are trying to do.

Was this reply helpful? Yes No