cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
HAEast
Regular Visitor

Return results from Azure SQL Data Warehouse for PowerApps

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": {}
}
1 ACCEPTED SOLUTION

Accepted Solutions
fchopo
Super User
Super User

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:

azuresql.png

 

Hope it helps!

Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

View solution in original post

1 REPLY 1
fchopo
Super User
Super User

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:

azuresql.png

 

Hope it helps!

Ferran

Did I answer your question? Please consider to mark my post as a solution to help others.
Proud to be a Flownaut!

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Community Calls Conversations

Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (3,978)