The flow would include the following steps: This solution makes it possible for you to revise your stored procedure query without needing to reopen and resave your app or flow.
![valentina studio sql server execute stored procedure valentina studio sql server execute stored procedure](https://www.mssqltips.com/tipimages2/4318_Analysing.png)
We will be using a SQL stored procedure for our array, but you could easily substitute any other action step that produces an array into the flow. You can now read an in-depth blog about Request – Response. Intermediate to advanced users may want to explore the “Request – Response” action, which will be featured in a subsequent blog. The method you will read about in this blog uses the Split() formula in PowerApps to parse a text string back into an array. You could call an Azure function or an Azure Logic App through a custom connector, but those are at a high level. There are many other methods of returning an array to PowerApps. Directly returning an array is not among that list, but it can still be done with a workaround you’ll learn about from reading further. Presently, the data that is returned can take the form of a text string, file, or email address.
![valentina studio sql server execute stored procedure valentina studio sql server execute stored procedure](https://www.mssqltips.com/tipimages2/6588_add-custom-stored-procedure-template-ssms-visual-studio-2019.001.png)
The Flow team released this new feature called “Respond to PowerApps” that now makes it easier to retrieve data than creating a custom connector. A flow that is triggered in PowerApps can return that data into the same instance of the app. This enables scenarios in which thousands of records can be called for viewing, editing, and shaping. You can read more about it here. Users who want to execute a SQL stored procedure in Flow can now send its resulting array into PowerApps.
![valentina studio sql server execute stored procedure valentina studio sql server execute stored procedure](https://www.valentina-db.com/images/frontslideshow/report_editor_1_frame-538x400-s.png)
Author’s note: this blog has been updated with a link to the Request – Response method.