Trouble expressing a null value in a Dataverse lookup column on a condition branch

[AbleAmazing]

Hello Team,

I have the following actions in a relatively simple flow:

I'm trying to create a conditional branch on a contact (value) lookup column in Dataverse. If the column is null, do one thing. If it is not null, do the other. Unfortunately, I can't seem to find the right way to express a null value for this data type in a condition. I have tried expressing the null value as follows:

• null as a text string
• null as an expression
• "" as a text string

I have also tried using empty expression:

empty(outputs('Get_Case')?['body/_primarycontactid_value']) is equal to true​

Nothing has worked. The flow continues to process as if the value is null each time even when it's not or just return an error. I have noticed that when the value actually is null in Dataverse, the column itself doesn't seem to be included in the raw output of the row I'm retrieving in the previous action--which doesn't make sense to me. I would expect that column to be included in the raw output whether it the value is null or not. I'm not limiting the columns in the Get row by ID action.

Any assistance is appreciated.

[abm]

Try the below under the IF condition equal 0

length(outputs('Get_Case')?['body/_primarycontactid_value')) 

[abm · Accepted solution]

Hi @AbleAmazing 

Ignore the above and I tried the below and worked.

Add a compose above the IF condition and map the value of the lookup, then check the run history.

Thanks

[AbleAmazing]

Thanks. Turns out I spent four hours being very stupid and didn't realize that our case table surfaces two separate contact columns in Power Automate and I was calling the wrong one.