If I use IsEmpty to test whehter lookup is returning any record, it always returns false. But with the same data source if I use IsBlank then it work as expected...
If(
IsEmpty(LookUp([@'CDS DS'], some filters)),
//do somthing, it will never get here...
)
If(
IsBlank(LookUp([@'CDS DS'], some filters)),
//do somthing, it will work as expected
)
I thought IsEmpty is the one to be used with a table and IsBlank with a string...
what have I missed here? Why IsEmpty is always returning false...?
