Skip to main content

Notifications

Copilot Studio - General
Answered

Covid-19 Chatbot with an updated db

Posted on by

Hello everyone, 

first let me apologize. The whole topic of chatbots and databases is a first for me. 

I would like to make a chatbot that could provide you with updated data on covid-19. How would I approach this? From my understanding, it is possible to achieve it by connecting a chatbot (MS PVA) to a database (MS SQL Server) using MS Power Automate and On-premise Gateway. The database would have to be updated using a web scraping program (suggestions?) to keep it updated with data obtainable on websites.

Am I missing something? Are there better solutions? Is the SQL database replaceable with datasets using json, xlsx or something integrated in the Microsoft environment? Is this project just too big for me altogether?

The chatbot is something I would like to personally build, but I'd like to know if I'm approaching it from the right direction. I did some research but the amount of information is overwhelming since this is something I have never done. Not even remotely.

I'll be glad for any tips and directions even ones not specific for PVA. 

Categories:
  • Verified answer
    cabata Profile Picture
    cabata 314 on at
    Re: Covid-19 Chatbot with an updated db

    hi @tpackt  I think is a good project and it depends on your time, if you want to have your solution quick maeby you can find for help on the Power Automate Part.

     

    Make the bot is relative easy and it depends on what you are going to respond to the client, so the first step y configure the topics.

     

    Then to use power automate you can follow this video: Power Virtual Agents and Power Automate - YouTube

    Then to keep your data updated, It depends on where is your main DB, if is a website then yes you can use web scraping.

    I think this project could be made in 3 weeks, so keep trying.

Helpful resources

Quick Links

Welcome to the Power Platform…

We are thrilled to unveil the newly-launched Power Platform Communities!…

Getting Started…

Welcome to the Power Platform Community! We appreciate your visit…

Welcome to the new Power Platform Community!…

We are excited to announce our new Copilot Cookbook Gallery in the Community…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 138,287

#2
RandyHayes Profile Picture

RandyHayes 76,308

#3
Pstork1 Profile Picture

Pstork1 63,172

Leaderboard