Skip to main content

Notifications

Power Platform Community / Forums / General / Covid-19 Chatbot with ...
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

Exciting News for Copilot Studio Communi…

Get ready to experience a whole new level of engagement with the Copilot Studio…

Celebrating the May Super User of the…

LaurensM is an exceptional contributor to the Power Platform Community…

Check out the Copilot Studio Cookbook…

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

Leaderboard

#1
renatoromao Profile Picture

renatoromao 6,459

#2
Pstork1 Profile Picture

Pstork1 1,954

#3
Expiscornovus Profile Picture

Expiscornovus 1,667