Type and Run a SQL Query inside PowerApps 05-04-2018 13:16 PM - last edited 02-19-2020 13:32 PM

[mr-dang]

Knowing how to return an array to PowerApps will make many more connectors useful to you. The existing "Execute a SQL query" action in Flow is now capable of sending its resulting array back into the app where it was triggered. This allows you to leverage the SQL language from within your apps and retrieve thousands upon thousands of records. To put this into perspective: you can type a query to filter objects in a gallery or dropdown menu in addition to the current capabilities in PowerApps.

watch?v=K_H5r0nzwy4

[robertinligo]

Just something else from Microsoft to break, FLOW the app should do its own work give the programming back to development.  This makes me want to Google!

[jrobles09]

Hello @mr-dang 

I need your help pls bro.

I have a problem, I dont know that more continue, because I want show results of my query in the label of the powerapps

In the collect, I have this formula in the buttton

But I am receiving in the collect, I see this