Hi all,
There are two tables:
TableA (ID_A,Name_A)
TableB (ID_B,Name_B,TableA_B(optional, Lookup to TableA))
I need to get rows from TableB which are not related to TableA.
ClearCollect(colUnrelatedToTableA(Filter(TableA,IsBlank(TableA_B.ID_A)))
It works fine but with delegation warning. Is there an option to get it without delegation warning?
There was an assumption to use "=Blank() " instead of "IsBlank()" but I haven't got it worked.