Problem Power Virtual Agents with SQL return Values Back to PVA

[msuser33]

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 

[renatoromao · Accepted 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"