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

橙子主题打折出售

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

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

留言板

发表回复

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

21V SharePoint Shell 登录 2025年02月07日

21V的不能直接用官网的,要参考如下代码:Connect-SPOService-Credenti...21VSharePointShell登录

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

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

热门文章

无法握住的故土 在我们心灵最温暖的角落,总有一寸土地是属于故乡的。虽然我们看似已远离故土,可骨子里对故乡的依恋却是从未冷却过。我们无论漂泊他乡,还是在繁华都市平步青云,可故乡的悠悠情思总会潜入梦乡与你缠绵。是儿时那一缕缕茉莉的清香萦绕在梦境,也是邻家那已锈迹斑斑的铁壶里,开出艳丽的花儿在梦的边缘摇曳。故土就这样根深蒂固地在我们的灵魂深处烙下深深的印记。 作者:Pastore Antonio
1596 浏览量
EWS(Exchange Service)基本使用(获取个人会议,会议室会议内容,会议室列表,发送会议,修改会议,删除会议) 最近公司要求和exchange服务对接,所以稍微研究了一下官方文档,做出以下总结,欢迎大家补充。先...EWS(ExchangeService)基本使用(获取个人会议,会议室会议内容,会议室列表,发送会议,修改会议,删除会议) 作者:Pastore Antonio
1585 浏览量
Sql Server 部署SSIS包完成远程数据传输 本篇介绍如何使用SSIS和作业完成自动更新目标数据任务。**温馨提示:如需转载本文,请注明...SqlServer部署SSIS包完成远程数据传输 作者:Pastore Antonio
1578 浏览量
SQL Server AG集群启动不起来的临时自救大招 背景前晚一朋友遇到AG集群发生来回切换不稳定的情况,情急之下,朋友在命令行使用命令重启WSFC集群...SQLServerAG集群启动不起来的临时自救大招 作者:Pastore Antonio
1571 浏览量
windows 下安装 memcahce 官网上并未提供Memcached的Windows平台安装包,我们可以使用以下链接来下载,你需...windows下安装memcahce 作者:Pastore Antonio
1566 浏览量