Unanswered

Cancel flow if SQL DB unreachable?

(0) Share

Report

Posted on by funkyman50

I have a flow that triggers on a pretty short timer. It is set to cancel if the SQL query returns no results, but if the server goes down the flow keeps running and returns a null value instead and causes my flow to fail.

Does anyone have a better technique than what I've come up with that could handle both Nulls and 0 len?

I have the same question (0)

All responses (3)

Answers (0)

PrasadAthalye on at

Like (1)

Report

Re: Cancel flow if SQL DB unreachable?

You can just add a check to see if its not null. Add this as first condition. Make sure to use Null as an expression by typing it in Expression section. Below is an example. If you are writing positive condition for error then use equal to.

Was this reply helpful? Yes No
Pstork1 68,271 Most Valuable Professional on at

Like (1)

Report

Re: Cancel flow if SQL DB unreachable?

You could add a Coalesce() function inside the length() to provide an empty string or array if the returned value is null.

Was this reply helpful? Yes No
funkyman50 21 on at

Like (0)

Report

Re: Cancel flow if SQL DB unreachable?

Thanks to both of you! I'll try the coalesce() add-in first because that'll be easier to plug in.

Was this reply helpful? Yes No