I am creating a flow in Power Automate to retrieve data from an Oracle database. Connection works find and the query works, but it’s giving me different results than if I run the same query in SQL Developer. When I run the query, in the where statement there are 11 values. In SQL Developer it only returns three results which is expected, but in Power Automate it is giving me all 11 results, and the JSON that is created has 10 empty arrays and one with the three records I want. Is there a way to get Power Automate to act like SQL Developer? I am using the Execute a Oracle Query connector since it’s a complex query with several joins. I am including a sample of the JSON output. And I know how to parse out the headers which is why I am not including them here. This is the schema.

I have the following JSON that comes from PowerBI (via the Power Automate button function)

I’m going to preface this question by saying I am new to Microsoft Power Automate and I am excited to learn what it can really do.