cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Question about Power Automate in Power Virtual Agents

Hi Guys,

 

I want to create a simple Power Virtual Agents within Power Automate. I want to say in PVA that a user want to Cancel his Order. So the bot ask the user what is your Order Number and when a user type his Order Number then I want to check his Order Number in my table in SQL Database.

 

I need here for a Power Automate (Flow), but I really don`t know how to create this in Flow and then how to do it in Power Virtual Agents.

 

Could you guys help me step by step? Thanks a lot!

 

This is what I created but it doesn`t work see below.

 

5.png

 

This is how the stored procedure looks like.

 

ALTER procedure [dbo].[OrderNumber]

@OrderNumber varchar(30)

 

6.png


AS

 

Select * from [dbo].[Customer] where [Ordernumber] = @OrderNumber

 

 

5 REPLIES 5
v-alzhan-msft
Community Support
Community Support

Hi @Anonymous ,

 

Could you please share a screenshot of the run history of the flow?

 

Best regards,

Alice       

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous
Not applicable

Hi @v-alzhan-msft ,

 

Of course! You see in my Flow I typed name Sheila in stead of OrderNumber, but this doesn`t matter because this is just a test.7.png8.png

An updated doc with a deeper example of how to us e Power Automate flows with Power Virtual Agents was published recently here:

https://docs.microsoft.com/en-us/power-virtual-agents/advanced-flow

 

It looks into details on how HTTP Response should be build properly, including filling out both Response schema and Body.

Hey @Anonymous 

 

Were you able to resolve this issue? If not, please check out my blog post here: https://www.bythedevs.com/post/getting-started-with-ms-power-virtual-agents-on-the-powerplatform

 

I see that you have the appropriate schema setup. In the response action, just add this text: 

 

{

"OrderNumber" : "Hi! Your order number is (select the attribute from dynamic content)"

 

And now you should be able to see the OrderNumber in the output variables in the PVA. 

 

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

v-alzhan-msft
Community Support
Community Support

Hi @Anonymous ,

 

Have your problem been solved?  If yes, please go ahead and mark the post as solved by clicking “Accept as Solution” so that this thread will be marked for other users to easily identify!

 

Best Regards,

Alice

 

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (2,147)