cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

MYSQL and Gateway

My question is about Gateways/MYSQL.

 

I have a checkin app for the lobby of an elementary school. Parents late dropping off/pickup early no longer use a sheet of paper, they do it on an app. The app writes checkin/out data to a Sharepoint Online list but Sharepoint has its data limitations. So, I plan to write the data to MYSQL. I connected MYSQL through Powerapps and installed a Gateway but all on my local machine. I realize the Gateway needs to be used on a computer that is always on. I believe we have a server at work that i could use. However, I'm a novice to this so here are my questions:

 

1. Would I need to log in to Powerapps from the server computer, install a new gateway or can i do it remote through my machine?

2. Can i connect everything from the MYSQL database on my machine or would i also need to install MYSQL on the server computer in order to connect data to it from the gateway?

 

Totally confused and I can't find literature online to my specific problem.

 

Guidance is appreciated. Thanks! 

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Dual Super User III
Dual Super User III

Re: MYSQL and Gateway

Sorry, hit enter too fast.

https://www.youtube.com/watch?v=sx0wCMrlMQc



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

3 REPLIES 3
Highlighted
Dual Super User III
Dual Super User III

Re: MYSQL and Gateway

The sound quality isn't great, but here's a YouTube video on how to setup MySQL and PowerApps with a data gateway.  But as I mentioned in my reply to your other post you really don't need MySql.  The MySQL database and gateway are both premium and will add licensing costs to the app.  



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Helper III
Helper III

Re: MYSQL and Gateway

@Pstork1 I don't see the link to the video. Can you repost it?

Highlighted
Dual Super User III
Dual Super User III

Re: MYSQL and Gateway

Sorry, hit enter too fast.

https://www.youtube.com/watch?v=sx0wCMrlMQc



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (5,700)