Unanswered

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

(1) Share

Report

Posted on 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.

Categories:

Power Automate Desktop

All responses (6)

Answers (0)

Sort by

PetrosF-MSFT Microsoft Employee on at

Like
a
(3)

Report
Copy link

Link copied!

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!
aqureshi 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Team Microsoft,
How to get Multiple Tables From Stored Procedure through Execute stored procedure (V2) in power automate.
Regards,
Ali W. Qureshi
AbdulSamadHMC 4 on at

Like
a
(1)

Report
Copy link

Link copied!

Is this functionality implemented?
HeribertoC 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Please tell us about any update. Regards!
skt2508MSPP 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Please any update on this?

Thanks/Santosh
DeepaliJagtap 68 on at

Like
a
(0)

Report
Copy link

Link copied!

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.