Source is a SQL Server, it on premise and connected through a gateway.
From Flow I call a Stored Procedure, in which I have declared an output parameter
@XMLFile XML OUTPUT
Now I don't get back the output parameters from my stored procedure, see picture
I noticed when I do this in an Azure SQL Server instance, so whithout a data gateway, it will return the output parameter as expected.
So my question is if anybody knows if this is a bug, a limitation or If I'm doĂŻng something wrong?
Hope someone can help.
Paul
Hi @v-yamao-msft , 4 years has passes, have this limitation been solved? How can I get an output parameter from a stored procedure when calling from Power Automate?
Hi
I got the output value using a function substring() with "Resultsets". For this operation, i had to create some variables before containing lenght about "Resultsets" and position number for some characteres to identify since and until.
Regards
Mitchel Arlés
Hi @KroonOfficeSol,
When invoking a Stored Procedure on an on-premises SQL Server, we have the following limitations:
Please check the following doc for more details:
https://docs.microsoft.com/en-us/connectors/sql/
Best regards,
Mabel
Michael E. Gernaey
7
Super User 2025 Season 1
vipuljain03
4
VictorIvanidze
2