However, I discovered that the records after 500th row are not displayed in the app (which seems to be not delegable in this case). I did not receive any error in the app related to delegation. Does anyone know if this formula is correct and delegable ?
If you want to get more records within your app, you could consider take a try to change the Non-delegable limits (Data row limit for non-delegable queries) within your app. The maximum value of the Non-delegable limits (Data row limit for non-delegable queries) is 2000currently.
Community Support Team _ Kris Dai If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I used Excel tables stored in OneDrive as my app's data source. at the time I wasn't aware of 500 limit on excel, once I noticed, increased the limit to the Max (2000 records) but it won't suffice and just give me a bit time to find a solution. So my question would be, is there any plan to increase the record limit on Excel or I need to change my data source? If so, would you let me know what I should do and what your recommendation is in this regard.