Showing results for 
Search instead for 
Did you mean: 

Enable delegation on lookup 'Id' column

Today, only the 'Value' part of a lookup column can be delegated through Filter, Lookup, =, ... functions:

Image 2.png

If you try filtering on the 'Id' part of the lookup column, then you get the delegation warning message:

Image 3.png

It would be nice to have the 'Id' column delegable as well, thus allowing us to workaround eventual duplicate 'Value' values and target more efficiently the correct item(s).

Status: New
Advocate V

Delegation issues are a pain, so every idea to reduce the pain gets my vote.

Advocate II

I noticed —-at least with CDS connector — that it gives delegation warning for a similar filter unless I wrap the data source in the filter with the Disambig @ sign.  For example: 



 ... Filter([@‘My Entity’], ‘My Entity’ = varRecord.’My Entity’)  ...


I don’t know what data source you’re using, but maybe this might help?

Advocate V

Thanks @NewcombR  I will try, I use SharePoint as a datasource.


Best regards,


Helper IV

It is very frustrating that delegation on lookup column IDs is not an option. This severely limits the value of using Power Apps and SharePoint.