cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
Dual Super User III
Dual Super User III

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
Dual Super User III
Dual Super User III

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.

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

Dual Super User III
Dual Super User III

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
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Top Solution Authors
Top Kudoed Authors
Users online (82,806)