Return results from Azure SQL Data Warehouse for PowerApps

[HAEast]

I'm discovering a lack of information about working with data returned from the Azure SQL Data Warehouse connection in PowerAutomate. My query is successful and I see the expected data in Output section of the query, but I've tried returning the output with a Response step, a ParseJSON step, and a Variable step without success. Would anyone be able to point me to a decent reference or examples? 

The query output isn't complex, so I can't understand why the solution seems to be so problematic.

{

  "ResultSets": {

    "Table1": [

      {

        "SerialNumber": "XXXXXXXX"

      }

    ]

  },

  "OutputParameters": {}

}

[fchopo · Accepted solution]

Hello @HAEast 

As I understand, you want to get the SerialNumber column value. You could use the following expression inside a compose action:

first(body('parse_json')?['ResultSets']?['Table1'])?['SerialNumber']

Have a look at this example which is working:

Hope it helps!

Ferran