Use MySQL views from Power Automate and Power Apps

If you have worked on a Power Platform project that needs connections to MySQL, then you might have noticed views are not listed when browsing the catalogue of a MySQL database.

In this blog post we bring you a quick trick on how to successfully retrieve data from MySQL views using Power Automate App Services smoothly integrating with Power GI!

Table of Contents

Power Apps

Go to the “Add data” section. 

Look for “MySQLconnector and then find the server you want to retrieve views from

Look for “MySQL” Connector
List of tables

In the next screen, you will get a list of tables to select from and you will notice that only tables are visible in the list

Enter Custom Table Name

To connect your app to the view, simply start typing the database name and the view name in the “Enter custom table name” box.

The final text should have this structure

database_name.view_name

Finally, click on the checkbox to select the view you typed in and then hit on “connect”

Click on the Checkbox to Connect

That’s it! Now your view will be listed in the data section

Data Section

You can start using it in galleries, tables or any control:

Data Section

Power Automate

Start a new flow and look for the MySQL connector, then select the Get rows action.

Look for “MySQL” Connector

Same as in Power Apps, views are not available in the list and only tables will be listed – just click on the “Enter custom value” option.

Enter Custom Value

To connect your flow to the view, simply start typing the database name and the view name in the box.

The final text should have this structure

database_name.view_name

Enter the Database Name

And that’s it! Now you can access all the rows and columns for this view!

Access all the Rows and Columns

You can also see a step-by-step walkthrough in our YouTube channel

https://www.youtube.com/watch?v=et9ygLjxfSY

Leave a Comment

Your email address will not be published. Required fields are marked *