How to access MySQL Views in PowerApps

[PytByt]

Hi all..

I need to know how is exactly to access Views in PowerApps using MySQL connection?

I already create the MySQL Connection and it was successful. Unfortunately, i only can access the tables of mt db and not a single view available.

Is there any specific way for me to get access to my Views using MySQL connection? or a way around for me to achieve this?

Please help.

Thanks.

[v-siky-msft · Accepted solution]

@PytByt 

As far as know,  Views from MySQL connector is not available in powerApps. PowerApps only support SQL Views, not MySQL Views.

Reference:https://powerapps.microsoft.com/en-us/blog/using-sql-server-views-in-powerapps/ 

If you want this feature, please submit an idea to PowerApps Idea Forum.

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas 

Sik

[PytByt]

Hi @v-siky-msft 

Thanks for the insight. Its bummer that PowerApps have the MySql connection as premium but not support the Views.

Cheers.

PytByt