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
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"
View solution in original post
Learn about the exciting things that happened in July.
Check out this Power Virtual Agents-Bot Variables, Multi-Language and working a Solution to learn more
We're excited to announce our first cross-community 'Can You Solve These?' challenge!