cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ersula82
Level: Powered On

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

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.
3 REPLIES 3
Super User
Super User

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.
ersula82
Level: Powered On

Re: MYSQL and Gateway

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

Highlighted
Super User
Super User

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.

Helpful resources

Announcements
firstImage

Microsoft Business Applications Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

firstImage

Watch Sessions On Demand!

Continue your learning in our online communities.

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

FirstImage

Power Platform World Tour

Coming to a city near you

thirdimage

PowerApps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

FourthImage

Join PowerApps User Group!!

Connect, share, and learn with your peers year-round

Top Kudoed Authors
Users Online
Currently online: 346 members 5,121 guests
Recent signins:
Please welcome our newest community members: