Today, only the 'Value' part of a lookup column can be delegated through Filter, Lookup, =, ... functions:
If you try filtering on the 'Id' part of the lookup column, then you get the delegation warning message:
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).
Delegation issues are a pain, so every idea to reduce the pain gets my vote.
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?
Thanks @NewcombR I will try, I use SharePoint as a datasource.
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.