PowerApps to an On-Site MySQL database

[DuncanKlysh]

Need some tech savy help.

I introduced PowerApps to my team and we started using it, however we were storing everythign to a SharePoint List this has less functionality than MySQL databases and is less secure.

We want to transition our tools to MySQL but I can't get my system to connect to the MySQL database.

The project leader managed it just fine, all they did was install on-premise data gateway, and they can connect no issue.

I did the same thing and I get an error message.

"Value 'Preferred' is not of the correct type. inner exception: Value 'Preferred' is not of the correct type. clientRequestId: 3aec81fe-4bf2-4d53-87f1-32b3cc68857a"

Any help would be appreciated

[v-monli-msft]

Hi @DuncanKlysh,

Please make sure that you have followed below documentation step-by-step to connect to your SQL Server from PowerApps:

https://blogs.msdn.microsoft.com/suvidha/2017/01/03/powerapps-with-sql-server-on-premises-using-the-...

Other references:

Connect to SQL Server from PowerApps

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/connections/connection-azure-sqldatabas...

Connect to your on-premises data sources from PowerApps using on-premises data gateway

https://powerapps.microsoft.com/en-us/blog/connect-to-your-on-premises-data-sources-using-on-premise...

Understand on-premises data gateways for Microsoft PowerApps

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/gateway-reference

Regards,

Mona