Return Multiple tables From Stored Procedure through Execute Sql Statement in power automate desktop

Like (1) Share

Report

Posted on 13 Nov 2020 06:29:20 by NeerajYadav Microsoft Employee

I am executing a SQL Stored Procedure by "Execute Sql statement" in power automate desktop The Stored Procedure returns 5 tables and I've checked that when I execute this in Management Studio, all tables are returned. When I execute this through power automate and examine the output body only the first table is shown to be returned .

Please help on this .

Thanks in advance.

All responses (6)

Answers (0)

DeepaliJagtap 68 on 10 Jan 2024 at 10:56:37

Like (0)

Report

Re: Return Multiple tables From Stored Procedure through Execute Sql Statement in power automate desktop

hi,
We were facing same challenge, so in order to resolve it, we separated the query into separate sql file and executed them one by one. If there is dependency between those query and if any temp tables are getting created then separate it out create all global temp table first and then execute actual table generating query one by one.
Please mark this as solution if it helps you solve issue. Happy to help you more.
skt2508MSPP 2 on 10 Jan 2024 at 07:25:41

Like (0)

Report

Re: Return Multiple tables From Stored Procedure through Execute Sql Statement in power automate desktop

Please any update on this?

Thanks/Santosh
HeribertoC 4 on 13 Jul 2023 at 15:22:50

Like (0)

Report

Re: Return Multiple tables From Stored Procedure through Execute Sql Statement in power automate desktop

Please tell us about any update. Regards!
AbdulSamadHMC 4 on 23 Feb 2023 at 08:11:29

Like (1)

Report

Re: Return Multiple tables From Stored Procedure through Execute Sql Statement in power automate desktop

Is this functionality implemented?
aqureshi 4 on 23 Feb 2023 at 07:56:50

Like (0)

Report

Re: Return Multiple tables From Stored Procedure through Execute Sql Statement in power automate desktop

Hi Team Microsoft,
How to get Multiple Tables From Stored Procedure through Execute stored procedure (V2) in power automate.
Regards,
Ali W. Qureshi
PetrosF-MSFT on 17 Nov 2020 at 13:39:59

Like (3)

Report

Re: Return Multiple tables From Stored Procedure through Execute Sql Statement in power automate desktop

Hi @NeerajYadav

Please note that the output variable of the "Execute SQL statement" Action is a data table variable.

Currently we don't have a way to store multiple data tables into a variable with a single action.

I will forward this request to the team to consider it for implementation.

Thank you!