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

View solution in original post

3 REPLIES 3
Highlighted
Dual Super User
Dual 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 Helper III
Helper III

Re: MYSQL and Gateway

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

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

View solution in original post

Helpful resources

Announcements
MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Power Platform 2020 release wave 1 plan

Power Platform 2020 release wave 1 plan

Features releasing from April 2020 through September 2020

Top Solution Authors
Top Kudoed Authors
Users online (7,301)