You’re offline. This is a read only version of the page.
Announcements
5
I run a simple Flow in PVA, the Flow run a stored Procedure and i want to return the result back to PVA but if i select the Result Value i get the following Error
Hi @msuser33 ,
Yes, you got an error because you are trying to insert a list value in an output string, Power Automate recognizes that is incompatible.
If you want to get the last value (because when you execute a procedure, return one or more than one item), follow these steps:
- Create an action called "Initialize variable" with type string on the beginning of the workflow
- Create an action called "Set variable", after the SQL action, select your created variable and the value will be the Dynamic content called "ResultSets...".
- Inside the final PVA action, use the variable created instead of "ResultSets"
Share
Report
All responses (
Answers (
