Using query with on-premise gateway

Like (1) Share

Report

Posted on 14 Mar 2025 15:57:26 by JH-22040758-2

I am getting an error just clicking in the query section when using an on-premise gateway. How or where do construct a query in Power Automate to send the information back to Power Apps?

Categories:

Licensing

All responses (1)

Answers (0)

Suggested answer

Michael E. Gernaey 36,029 Super User 2025 Season 1 on 14 Mar 2025 at 23:52:40

Like (0)

Report

Using query with on-premise gateway

Hi @JH-22040758-2

So the error you are getting there, isn't related to sending data back, its simply doing something that isn't supported.

If you want to send data back to a Canvas App or Model-Driven App, you must take the data you get from (whatever actions you do) and (the best way) is to form is into a JSON format.

Then use the Response to a Power App action, and send it back via an outgoing string property.

Then inside the App use the ParseJSON function (or depending on what you did back parse somehow) the data you want into something you can use.

The above though isn't related to passing back data, its related to making an unsupported call.

So make a copy to SQL

Get your Data

Use the Data to build a JSON structure

Pass it back as a string in an Output parameter

Reconstruct it into a Collection (aka JSON) in the App