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

Covid-19 Chatbot with an updated db

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. 

1 ACCEPTED SOLUTION

Accepted Solutions
ChristianAbata
Super User II
Super User II

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.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

1 REPLY 1
ChristianAbata
Super User II
Super User II

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.



Did I answer your question? Please consider to Mark
my post as a solution! to guide others :winking_face:

Proud to be a Flownaut!


If you want you can follow me at www.christianabata.com Quieres contenido en español? Síguenos en Power Automate LA

View solution in original post

Helpful resources

Announcements
March Update

Welcome to the User Group Private Preview

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

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (12,532)