Unanswered

Flow failing when SQL query returns empty set

(0) Share

Report

Posted on by DBean

I've created a flow that fails when the SQL query returns an empty set. I've found lots of mentions of similar issues, but none that include a solution.
This is a very simple flow - I'm searching a database for employees with a given start date, and sending an email to each of them. Often, though, there are no employees with a particular start date, and the flow fails.

I've tried this:

And that doesn't work:

I found mentions of an "Empty" function, but when I try using that instead of "Null", I get this:

Any thoughts? Thanks in advance!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Paulie78 8,422 Moderator on at

Like (1)

Report
The SQL connector returns a bunch of outputs, I would suggest you use something like:

not(empty(outputs('Execute_a_SQL_query_(V2)')?['body/resultsets/Table1']))

On the left side of your condition and the true expression on the right side. Make sure you use the expression true, not just type true in, like this:

Was this reply helpful? Yes No
DBean 17 on at

Like (0)

Report

@Paulie78 That did the trick - thanks!

Was this reply helpful? Yes No