Answered

Replace null with a value

(1) Share

Report

Posted on by send2mark

505

Using a Compose action, how can I when a null value is presented provide some generic value. So if x=null enter 1. I have an array variable going to an initialize variable using the array type and it is failing because of the null value.

Categories:

General topics

I have the same question (0)

All responses (3)

Answers (1)

Suggested answer

MP-08080224-0 2 on at

Like (1)

Report
Copy link

Link copied!
The coalesce function returns the first non-null value. So, you can do this:

coalesce(<the value that might be null>,<the value you want to replace nulls>)

or, using the values supplied in the original post:

coalesce(x,1)

Was this reply helpful? Yes No
Tryin2Flow 7 on at

Like (1)

Report
Copy link

Link copied!

This worked great for my flow. Needed to create a "0" value when null and the entered value when not null. In compose > expression

Was this reply helpful? Yes No
Verified answer

manuelstgomes 6,625 on at

Like (4)

Report
Copy link

Link copied!
Hi @send2mark

Here's the formula:

if(equals(<VALUE TO TEST>,null),'Value if null','value if not null')

You can check if the value is null or not. If it's not null you can put in the formula the same value otherwise your default value.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

Was this reply helpful? Yes No