Getting just value from SQL Stored Procedure

(0) Share

Report

Posted on by oriolvillorbina

Good Morning,

I have the next issue when I use Power Automate to execute a SQL Stored Procedure,

The issue, is that I can access to the data on a proper way, but I get all the result set, ex: Encantado {“Table1”:[{“Nombre”:“Prueba Prueba Prueba”}]},

The fact is that I just receive the value when I save the variable with the value ResultSets, on a logic way I think that the one would be OutputParameters, but I don't get any value when I return the variable with the OutputParameters value,

Anyone has faced this problem, and how I can get just the name {“Table1”:[{“Nombre”:“Prueba Prueba Prueba”}]} -> Prueba Prueba Prueba.

Captura de pantalla 2021-06-02 113527.png

Many thanks to all,

Regards,

Categories:

Building flows

I have the same question (1)

All responses (2)

Answers (0)

rrovira Microsoft Employee on at

Like (0)

Report

Hello, @oriolvillorbina!

I'm investigating a little bit to see if I find a workaround or if someone figured out how to fix this. In the meantime, I'd like to ask if you have an on-premise server. Solved: SQL Stored Procedure - Output parameters - Power Platform Community (microsoft.com) → The known limitations of the action include information about restrictions when it comes to on-premise servers.

I'd like to know something, when you return the employee name and you store it in a variable, what you are getting is the Encantado {“Table1”:[{“Nombre”:“Prueba Prueba Prueba”}]} value, right? So, the variable is not empty?

Was this reply helpful? Yes No
rrovira Microsoft Employee on at

Like (0)

Report

I'm not sure if this might help, but there's no harm in taking a look. Let me know if this gives an idea: Solved: Extracting Key data from SQL Query - Power Platform Community (microsoft.com)

Was this reply helpful? Yes No