Problem Power Virtual Agents with SQL return Values Back to PVA

(0) Share

Report

Posted on by 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

Categories:

General

All responses (1)

Answers (1)

Verified answer

CU22081450-0 Most Valuable Professional on at

Like (1)

Report

Re: Problem Power Virtual Agents with SQL return Values Back to PVA

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"