Get data in 'DataTable' executing "Stored procedure" in SQL server

[vk1]

Hi All,

I want to get data in 'DataTable' executing "Stored procedure" in SQL server. I created a flow to execute SP and it is executing fine .

Could someone please help me to get the data in 'DataTable'.

Thanks,

Vikram

 

[timl · Accepted solution]

@vk1 

I'm assuming that you want to retrieve the data in 'DataTable' in order to return it to Power Apps.

If that's the case, the following article by Brian Dang describes how to do this. The key step is to add a Response action.

https://powerapps.microsoft.com/en-us/blog/return-an-array-from-flow-to-powerapps-response-method/