cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Problem Power Virtual Agents with SQL return Values Back to PVA

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 

SQL.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User
Super User

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"


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Power Virtual Agents course (FREE): https://www.udemy.com/pva-beginners

View solution in original post

1 REPLY 1
Highlighted
Super User
Super User

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"


Did I answer your question? Mark my post as a solution!
Thanks!

Renato Romão,

Power Virtual Agents course (FREE): https://www.udemy.com/pva-beginners

View solution in original post

Helpful resources

Announcements
PVA Community Highlights

July 2020 Community Highlights

Learn about the exciting things that happened in July.

PVA-BotVariablesMulti-Language

PVA Bot Variables, Multi-Language

Check out this Power Virtual Agents-Bot Variables, Multi-Language and working a Solution to learn more

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

Top Solution Authors
Users online (7,947)