We have a list named Large123, and inside another list we define a lookup field named ll to reference the Large123 list, as follow:

enter image description here

but when we try to do a Lookup formula on the Lookup SharePoint field inside our Power Apps, we always get Delegation warning, as follow:

enter image description here

but if we change the formula to be as follow, the delegation warning will get disappeared:

enter image description here

So can anyone advice on this? why one formula raised a delegation warning while the other did not?

1 Answer 1


This is a known issue related to Power apps delegation and SharePoint lookup columns. Delegation only works with the lookup value (column selected under "In this column" option in lookup settings). The additional (extended) columns are not supported in delegation.

enter image description here

Similar threads/Source:

  1. Delegation warning on SharePoint list lookup column .Id versus .Value
  2. SharePoint Lookup Column Id Subfield - Filter Gallery Items - Delegation Warning

Documentation: Power Apps delegable functions and operations for SharePoint

  • thanks for the info,, so documentation such as the one on this link powerusers.microsoft.com/t5/Power-Apps-Community-Blog/… ,, which mentioned to use numeric fields instead of lookup fields is not 100% correct?
    – John John
    Commented Aug 21, 2022 at 18:04
  • 1
    This approach also works if you are adding/updating data to child list using powerapp/any other automation. But, if users are adding data to child list manually, they have to go to parent list, note ID column, go to child list & then add ID to parentID column in child list manually. Commented Aug 22, 2022 at 3:26

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.