cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
cooneyrmic
Regular Visitor

Can't Find App Checker Delegation Warning

The App Checker for my canvas app, which is connected to SharePoint Libraries, shows a Warning under Performance specifically the for the "App" screen/On Start location. The warning says:

 

"Data row limit for non-delegable queries is more than 500"

 

In the "On Start" code, there are no blue squiggly lines, there are no yellow triangles and the only queries I'm using is LookUp, which the documentation says is delegable. Additionally, I have been copy/pasting the "On Start" codes into the "On Visible" of my Home Screen because that seems to be more efficient during troubleshooting. There is no delegable warning on that screen. I even took the step of delete all the code out of both screens and the warning is still there in the  App Checker. There are no other delegable warnings in the rest of the app either.
Am I missing something?

2 REPLIES 2
eka24
Super User III
Super User III

How many rows do you have in the Table.

Go to File then Advanced Settings then scroll to Delegation and increase it to 2000.

------------

If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

 

timl
Super User III
Super User III

Hi @cooneyrmic 

This message is saying that in the advanced settings, the 'data row limit for non-delegable queries' setting is greater than the default value of 500.

It is not suggesting that you have used any non-delegable queries in your app, so this is a warning you can ignore.

Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Power Query PA Forum 768x460.png

Check it out!

Did you know that you can visit the Power Query Forum in Power BI and now Power Apps

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,702)