My flow runs a query to get records from the database using Execute a SQL Query (V2). Then is enters into Apply to each loop. But sometimes the query will return no results (which is expected). I am currently getting the error below. How to I not go into the Apply to each loop if there are no records returned from the query?
The execution of template action 'Apply_to_each_2' failed: the result of the evaluation of 'foreach' expression '@body('Execute_a_SQL_query_(V2)')?['resultsets']?['Table1']' is of type 'Null'. The result must be a valid array.
Solved! Go to Solution.
I have found a workaround. I am checking if the table object is null using a "Condition"
I have found a workaround. I am checking if the table object is null using a "Condition"
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
5 | |
3 | |
3 | |
2 | |
2 |
User | Count |
---|---|
14 | |
12 | |
8 | |
7 | |
6 |