How to Lookup EXCEL DATA with Microsoft Power Virtual Agents

Imagine the time and effort you could save by having your Microsoft Power Virtual Agents chatbot return data from your Microsoft Excel table!

In this Power Virtual Agents tutorial I’ll show you how to create a Power Virtual agents topic that calls on a Power Automate flow to look up information in an Excel Table and return it in a neatly formatted chatbot message.

If you aren’t familiar with creating topics in Power Virtual Agents—watch THIS VIDEO FIRST: 🤖 CREATE A CHATBOT for Microsoft Team...

IN THIS VIDEO:
✅ How to Add a Multiple Choice Question to Power Virtual Agents
✅ How to Create a Power Automate Flow for Power Virtual Agents
✅ How to Lookup Excel Data in a Table and Return Results to Power Virtual Agents
✅ How to use the Switch Action in Power Automate
✅ How to Format text in Power Automate for Power Virtual Agents
---

SKIP AHEAD:
0:00 Intro
0:27 Edit the Topic
1:41 Create the Flow
4:55 Set the Variable
8:20 Send Data back to the Chatbot
11:27 Chatbot Demo
12:03 Format the Output

SUBSCRIBE FOR NEW VIDEOS EVERY WEEK-ISH
👉 https://bit.ly/SubACreativeOpinion 👈

---
Teaching you how to make your workflows SUCK LESS.

Subscribe if you want to learn how to streamline your workflow, boost your productivity, and build innovative processes for yourself and your business! I wanna help you get more time in back your day.

Join me on my journey on learning new tools, levelling up my skills and creating more time to do the things that matter. I hope that I can inspire you to do the same and share all the things you learn from me with others.

Get curious. Be creative. Do better.

---

FOLLOW ME:
Instagram: acreativeopinion
TikTok: acreativeopinion
Twitter: acreativeop