Answered

Coalesce function not working within Condition Control Action

(2) Share

Report

Posted on by Adam_Travers

Hi All,

We have a Flow that requires to check if a Whole Number field is greater than or equal to 0 but it fails with the subject error as its returning a Null value if no numeric value has been set for the field. Looking into this I thought I can simply use the coalesce function which works and returns a 0 within my Compose Action but when the Compose Action is used within Condition Control Action I see get the same error even though the value is set to 0 by the Coalesce Formula. Does anyone know why this is happening and how to fix it?

Error: The template language function 'lessOrEquals' expects all of its parameters to be either integer or decimal numbers. Found invalid parameter types: 'Null'

Formula: coalesce(outputs('Get_Company')?['body/byt_totalusers'],int(0))

Categories:

General topics

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

CA1105 545 Super User 2025 Season 2 on at

Like (1)

Report

HI @Adam_Travers,

I guess you are looking at the wrong parameters since error is saying expression is wrong for "LessOrEquals". Check value for below condition.

Was this reply helpful? Yes No
Adam_Travers 46 on at

Like (0)

Report

Hi,

Many thanks for the response. I still get the error if I change it to the below, however, if I just have a single condition using my Compose field it works.

Was this reply helpful? Yes No
Verified answer

Adam_Travers 46 on at

Like (0)

Report

Hi, I have managed to fix this so many thanks for your help.

Was this reply helpful? Yes No
David_MA 12,982 Super User 2025 Season 2 on at

Like (1)

Report
According to the error message, the coalesce function is returning null. Based on the conversation, I am not sure if you updated you coalesce statement. If you haven't update it to one of these two expressions:

coalesce(outputs('Get_Company')?['body/byt_totalusers'],int('0'))

coalesce(outputs('Get_Company')?['body/byt_totalusers'],0)

If you don't understand the difference from what you have:

Putting the single quotes around 0 makes it a string. The int() expression is used to convert a string to an integer.

Just using 0 requires no conversion since 0 is already an integer.

I am pretty sure either should work but don't have the time to test them right now.

Was this reply helpful? Yes No