Power Apps

Delegation Warning in Power Apps Lookup Formula

(0) Share

Report

Posted on by 11manish

3,333

We are currently seeing a delegation warning in our Power Apps formula:

"Delegation warning. The 'LookUp' part of this formula might not work correctly on large data sets."

Filter(
Countries,
'Default Label' = LookUp(
'Corporate Accounts',
Account.Account = GUID(accountReacordId),
'Address 1: Country'
).'Default Label'
)

However, the table we are using contains fewer than 2000 records. Could you please help us understand why this warning is appearing and whether there is something we should adjust in the formula or configuration?
Any guidance would be appreciated.

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Suggested answer

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hey @11manish,

This is just a warning. So it comes up even when you only have one record, so that you are aware of this limitation.

If you are sure, that the table will never have more than 2000 records you can ignore this warning.

If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!

Thanks, and happy building!

Was this reply helpful? Yes No
11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!

@Daniel Bocklandt, Yes, you are right.

The formula is quite simple, but it is still showing a warning.

I was just curious to know if I am the only one seeing this warning, or if others have also experienced it and found a way to resolve or avoid it. If there is a solution, I would appreciate learning about it, as I may be missing something due to a gap in my understanding.

Was this reply helpful? Yes No
Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

The actual issue is inside of this lookup:

LookUp(
'Corporate Accounts',
Account.Account = GUID(accountReacordId),
'Address 1: Country'
)

So you go inside the account table and you go down a relationship. and that's the issue. Using a relationship in any way inside of lookups resolut in delegation warnings.

I don't really understand what you are filtering for, but if you manage to filter or use the lookup without using the relationships the warning will disapear.

If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!

Thanks, and happy building!

Was this reply helpful? Yes No
11manish 3,333 on at

Like
a
(0)

Report
Copy link

Link copied!

I am trying to set the default country value based on the Corporate Account’s country that is retrieved during the search.

In other words, when a Corporate Account is found through the search, the country field should automatically be populated with the country value from that Corporate Account.

Was this reply helpful? Yes No
Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Than you should be able to take it directly from there instead of searching for it again in the Fliter and lookUp formula.

Since you have your corporate account already found in the search simply reuse it.
If this solved your problem, please mark it as Solved to help others find the solution faster.
If you found it helpful, consider giving it a Like to support each other in this community!

Thanks, and happy building!

Was this reply helpful? Yes No
Kalathiya 2,456 Super User 2026 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!
Hello @11manish,

Please try below approach:

With( { varCountry: LookUp( 'Corporate Accounts', Account.Account = GUID(accountReacordId), 'Address 1: Country' ) }, Filter( Countries, 'Default Label' = varCountry.'Default Label' ) )

If this response resolves your issue, please mark it as the Verified Answer so it can help other community members as well.

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

📩 Need more help? Mention @Kalathiya anytime!
✔️ Don’t forget to Accept as Solution if this guidance worked for you.
💛 Your Like motivates me to keep helping!

Was this reply helpful? Yes No