We have a list named Large123, and inside another list we define a lookup field named ll to reference the Large123 list, as follow:
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:
but if we change the formula to be as follow, the delegation warning will get disappeared:
So can anyone advice on this? why one formula raised a delegation warning while the other did not?