How to handle no records returned from Execute a SQL Query (V2)?

[BrianH]

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.

[BrianH · Accepted solution]

I have found a workaround. I am checking if the table object is null using a "Condition"