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!
Solved! Go to Solution.
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:
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:
Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!
User | Count |
---|---|
85 | |
60 | |
51 | |
43 | |
38 |
User | Count |
---|---|
89 | |
81 | |
74 | |
62 | |
44 |