How to Prevent Error during Condition Expression Check iwhen CC Field is "Null"

(0) Share

Report

Posted on by ACECORP

I have a power automate flow that is using the conditional expression shown below.

Unfortunately, I am getting an error every time the CC Field is null, as shown below, which is 8 times out of 10. It WILL be null most times, and I need to handle it.

On the left side, I need to check if the CC field of an email contains a certain value.

In most cases the CC field is null, and that breaks the flow.

This is a very large and complex flow that does many things under many conditions so I cannot break out this CC portion because I will hit a limit.

What can I do on the left side to “handle” the fact the CC will be null 80% of the time so the fact it is null won’t generate hundreds or thousands of errors and prevent the flow from executing?

Any help, guidance, or suggestions would be greatly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Pstork1 68,717 Most Valuable Professional on at

Like (3)

Report

The Coalesce function can be used to intercept a null value and replace it with a default value or a blank string. That would keep the condition from failing.

Coalesce(<<cc value>>,"")

----------------------------------------------------------------------------------
If this Post helped you, please click "Does this answer your question" and give it a like to help others in the community find the answer too!

Paul Papanek Stork, MVP
Blog: https://www.dontpapanic.com/blog

Was this reply helpful? Yes No
ACECORP 19 on at

Like (0)

Report

@Pstork1 thanks... we are getting closer... but not there yet. When I do that, I get the error message below.

What am I missing?

Was this reply helpful? Yes No
ACECORP 19 on at

Like (0)

Report

@Pstork1 -- my bad... I fixed it..

the below was the fix..

Coalesce(triggerOutputs()?['body/ccRecipients'],'')

Thanks so much for getting me on the right track!

Was this reply helpful? Yes No