Answered

How to handle null data in Condition?

(0) Share

Report

Posted on by CW-23070243-0

I created a "Condition" to determine whether "customerId text" contains "txt" or is empty (sometimes AI builder can't get customerId from invoices). But it keeps showing the following error。

"customerId text" is from AI builder.

could you please help me with it ?

Thanks

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Mark Nanneman 991 Super User 2025 Season 2 on at

Like (2)

Report
Copy link

Link copied!

To handle null errors in conditions like this, try using a coalesce function. Coalesce goes with the first object/value you give that isn't null.

coalesce(<your_string_input>,'')

If your input is a null, the coalesce will go with the '', which is technically not a null, and it can be checked by the condition for the substring, and it will return a false.

Was this reply helpful? Yes No
Chriddle 8,504 Super User 2025 Season 2 on at

Like (0)

Report
Copy link

Link copied!

Just switch the order (first chek for null)

Was this reply helpful? Yes No