Logo

Use MySQL views from Power Automate and Power Apps

photo

2025年02月11日

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 from both Power Automate and Power Apps!

Table of Contents

  1. Power Apps
  2. Power Automate

Power Apps

Go to the “Add data” section. 

Look for “MySQL” connector 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

橙子主题打折出售

其实我不卖,主要是这里是放广告的,所以就放了一个
毕竟主题都没做完,卖了也是坑.

购买它
本文为原创文章,请注意保留出处!

留言板

发表回复

您的邮箱地址不会被公开。 必填项已用 * 标注

清除AD RMS的配置 2025年03月07日

要清除ADRMS的配置以便重新安装,需要删除ADRMS的服务连接点(SCP)以及相关的配置信息。...清除ADRMS的配置

热门文章

C#图片处理 通常对一幅图片的处理包括:格式变换,缩放(Scale),翻转(Rotate),截取(Clip),滤镜...C#图片处理 作者:Pastore Antonio
1715 浏览量
memcached 处理 多端口:https://blog.csdn.net/Erica_1230/article/deta...memcached处理 作者:Pastore Antonio
1673 浏览量
AssemblyInstaller 的应用 usingSystem;usingSystem.Configuration.Install;us...AssemblyInstaller的应用 作者:Pastore Antonio
1665 浏览量
WordPress上传文件大小限制修改 WordPress上传媒体文件默认大小限制是2M或8M,当文件大于这个限定大小时,是上传不了的。其实...WordPress上传文件大小限制修改 作者:Pastore Antonio
1639 浏览量
Layui开发日记 丰富版table:https://saodiyang.gitee.io/layui-soul-ta...Layui开发日记 作者:Pastore Antonio
1591 浏览量