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?

Categories:

Building flows

All responses (3)

Answers (0)

Sort by

PrasadAthalye on at

Like
a
(1)

Report
Copy link

Link copied!

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.
Pstork1 69,665 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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

Like
a
(0)

Report
Copy link

Link copied!

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