Answered

Flow failing when SQL query returns empty set

Like (0) Share

Report

Posted on 21 Jan 2021 19:30:56 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!

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

Paulie78 8,418 Moderator on 22 Jan 2021 at 00:13:06

Like (1)

Report
Re: Flow failing when SQL query returns empty set

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 22 Jan 2021 at 17:07:47

Like (0)

Report

Re: Flow failing when SQL query returns empty set

@Paulie78 That did the trick - thanks!

Was this reply helpful? Yes No