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.
coalesce(<the value that might be null>,<the value you want to replace nulls>)
coalesce(x,1)
This worked great for my flow. Needed to create a "0" value when null and the entered value when not null. In compose > expression
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