cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Amran
New Member

PVA Data Lookup

I want to create a chatbot for information services and check for goods order status in the procurement department. This chatbot will function as an information / helpdesk section. Can I create a chatbot that allows users to search the status of the order process by matching the transaction number with our OneDrive Excel Procurement Database (lookup) ?

3 ACCEPTED SOLUTIONS

Accepted Solutions
renatoromao
Super User
Super User

Hi @Amran ,

 

Yes, sure, you can do it!

You can use the logic around the Power Automate following this video: https://powerusers.microsoft.com/t5/Bot-Sharing-Gallery/Health-bot-Calculate-your-BMI-metrics/td-p/6...

 

Basically, you need to create a question inside the PVA topic that gets the order number to the user.

When you get the order number, you can send the number to the Power Automate workflow like an input.

Inside the Power Automate workflow, you can connect with the Excel file using the OneDrive connector: https://docs.microsoft.com/en-us/connectors/onedrive/

 

When you get the data from your Excel file, you can return to the PVA following my video and create a message inside the PVA topic to show the output variable.


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

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.300 students | PROMOTIONS) : English | Português

View solution in original post

Thanks for your enlightment,. i'm still new in this. what script do i use to call this power automate action? 

 

Amran_1-1602216315098.png

 

View solution in original post

Hi @Amran ,

 

You need to have the "Return value(s) to Power Virtual Agents" block as the last item. That's the return block for the flow, which hands off the results to the bot.

 

Can you try moving that to the end and try again?

View solution in original post

5 REPLIES 5
renatoromao
Super User
Super User

Hi @Amran ,

 

Yes, sure, you can do it!

You can use the logic around the Power Automate following this video: https://powerusers.microsoft.com/t5/Bot-Sharing-Gallery/Health-bot-Calculate-your-BMI-metrics/td-p/6...

 

Basically, you need to create a question inside the PVA topic that gets the order number to the user.

When you get the order number, you can send the number to the Power Automate workflow like an input.

Inside the Power Automate workflow, you can connect with the Excel file using the OneDrive connector: https://docs.microsoft.com/en-us/connectors/onedrive/

 

When you get the data from your Excel file, you can return to the PVA following my video and create a message inside the PVA topic to show the output variable.


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

Renato Romão,

Connect with me here 😉

Power Virtual Agents course (+2.300 students | PROMOTIONS) : English | Português

View solution in original post

Thanks for your enlightment,. i'm still new in this. what script do i use to call this power automate action? 

 

Amran_1-1602216315098.png

 

View solution in original post

i got this error message as well :

 

Amran_0-1602216719533.png

 

Hi @Amran ,

 

You need to have the "Return value(s) to Power Virtual Agents" block as the last item. That's the return block for the flow, which hands off the results to the bot.

 

Can you try moving that to the end and try again?

View solution in original post

Thank you for your support.

Helpful resources

Announcements
March Update

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MSFTBizAppsLaunchEvent

Experience what’s next for Power Virtual Agents

See the latest Power Virtual Agents innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

New Super Users

Meet the Power Virtual Agents Community Super Users!

Congratulations to our Season 1 2021 Super User Crew!

Top Solution Authors
Top Kudoed Authors
Users online (89,993)