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
Solved! Go to Solution.
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"
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"
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
8 | |
5 | |
2 | |
2 | |
2 |