Azure Database for MySQL

Azure Database for MySQL Flexible Server provides a fully managed database service for app development and deployment with built-in capabilities, such as high availability, read replicas, custom maintenance and more. Use the connector to connect to Azure database for MySQL Flexible Server databases to read/write data and trigger workflows when your data changes.

This connector is available in the following products and regions:

Service	Class	Regions
Logic Apps	Standard	All Logic Apps regions
Power Automate	Premium	All Power Automate regions
Power Apps	Premium	All Power Apps regions

Connector Metadata
Publisher	Microsoft
Website	https://go.microsoft.com/fwlink/?linkid=2136898
Privacy policy	https://go.microsoft.com/fwlink/?linkid=512132

Creating a connection

The connector supports the following authentication types:

Basic Authentication	Use a username and password to access your MySQL database.	All regions	Shareable
Default [DEPRECATED]	This option is only for older connections without an explicit authentication type, and is only provided for backward compatibility.	All regions	Not shareable

Basic Authentication

Auth ID: mysqlAuthentication

Applicable: All regions

Use a username and password to access your MySQL database.

This is shareable connection. If the power app is shared with another user, connection is shared as well. For more information, please see the Connectors overview for canvas apps - Power Apps | Microsoft Docs

Name	Type	Description	Required
Server	string	Specify the MySQL server.	True
Database Name	string	Specify the MySQL database name.	True
Username	securestring	Username credential	True
Password	securestring	Password credential	True
Encrypt Connection	bool	Encrypt Connection

Default [DEPRECATED]

Applicable: All regions

This option is only for older connections without an explicit authentication type, and is only provided for backward compatibility.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Throttling Limits

Name	Calls	Renewal Period
API calls per connection	200	60 seconds

Actions

Delete row	This operation deletes a row from a table.
Execute a MySQL query	Execute a MySQL query
Execute Stored Procedure	This operation runs a stored procedure.
Get row	This operation gets a row from a table.
Get rows	This operation gets rows from a table.
Get Stored Procedures	This operation gets stored procedures for a database.
Get tables	This operation gets tables from a database.
Insert row	This operation inserts a new row into a table.
Update row	This operation updates an existing row in a table.

Delete row

Operation ID:

DeleteItem

This operation deletes a row from a table.

Parameters

Name	Key	Required	Type	Description
Server name	server	True	string	Name of MySQL server
Database name	database	True	string	Database name
Table name	table	True	string	Name of table
Row id	id	True	string	Unique identifier of the row to delete

Execute a MySQL query

Operation ID:

ExecutePassThroughNativeQuery

Execute a MySQL query

Parameters

Name	Key	Required	Type	Description
Server name	server	True	string	Name of MySQL server
Database name	database	True	string	Database name
Query	query	True	dynamic	query body

Returns

The outputs of this operation are dynamic.

Execute Stored Procedure

Operation ID:

ExecuteProcedure

This operation runs a stored procedure.

Parameters

Name	Key	Required	Type	Description
Server name	server	True	string	Name of MySQL server
Database name	database	True	string	Database name
Procedure name	procedure	True	string	Name of stored procedure
Parameters list	parameters	True	dynamic	Input parameters to the stored procedure

Returns

The outputs of this operation are dynamic.

Get row

Operation ID:

GetItem

This operation gets a row from a table.

Parameters

Name	Key	Required	Type	Description
Server name	server	True	string	Name of MySQL server
Database name	database	True	string	Database name
Table name	table	True	string	Name of MySQL table
Row id	id	True	string	Unique identifier of the row to retrieve

Returns

The outputs of this operation are dynamic.

Get rows

Operation ID:

GetItems

This operation gets rows from a table.

Parameters

Name	Key	Required	Type	Description
Server name	server	True	string	Name of MySQL server
Database name	database	True	string	Database name
Table name	table	True	string	Name of MySQL table
Filter Query	$filter		string	An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Order By	$orderby		string	An ODATA orderBy query for specifying the order of entries.
Maximum Get Count	$top		integer	Maximum number of entries to retrieve (default = 512).
Skip Count	$skip		integer	The number of entries to skip (default = 0).
Select Query	$select		string	Specific fields to retrieve from entries (default = all).

Returns

The outputs of this operation are dynamic.

Get Stored Procedures

Operation ID:

GetStoredProcedures

This operation gets stored procedures for a database.

Parameters

Name	Key	Required	Type	Description
Server name	server	True	string	Name of MySQL server
Database name	database	True	string	Database name

Returns

Represents a list of procedures.

Body

ProceduresList

Get tables

Operation ID:

GetTables

This operation gets tables from a database.

Parameters

Name	Key	Required	Type	Description
Server name	server	True	string	Name of MySQL server
Database name	database	True	string	Database name

Returns

Represents a list of tables.

Body

TablesList

Insert row

Operation ID:

PostItem

This operation inserts a new row into a table.

Parameters

Name	Key	Required	Type	Description
Server name	server	True	string	Name of MySQL server
Database name	database	True	string	Database name
Table name	table	True	string	Name of table
Row	item	True	dynamic	Row to insert into the specified table

Returns

The outputs of this operation are dynamic.

Update row

Operation ID:

PatchItem

This operation updates an existing row in a table.

Parameters

Name	Key	Required	Type	Description
Server name	server	True	string	Name of MySQL server
Database name	database	True	string	Database name
Table name	table	True	string	Name of table
Row id	id	True	string	Unique identifier of the row to update
Row	item	True	dynamic	Row with updated values

Returns

The outputs of this operation are dynamic.

Triggers

When an item is created	Triggers a flow when an item is created in MySQL
When an item is modified	Triggers a flow when an item is modified/inserted in MySQL

When an item is created

Operation ID:

GetOnNewItems

Triggers a flow when an item is created in MySQL

Parameters

Name	Key	Required	Type	Description
Server name	server	True	string	Name of MySQL server
Database name	database	True	string	Database name
Table name	table	True	string	Name of MySQL table
Filter Query	$filter		string	An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Top Count	$top		integer	Total number of entries to retrieve (default = all).
Order By	$orderby		string	An ODATA orderBy query for specifying the order of entries.
Select Query	$select		string	Specific fields to retrieve from entries (default = all).

Returns

The outputs of this operation are dynamic.

When an item is modified

Operation ID:

GetOnUpdatedItems

Triggers a flow when an item is modified/inserted in MySQL

Parameters

Name	Key	Required	Type	Description
Server name	server	True	string	Name of MySQL server
Database name	database	True	string	Database name
Table name	table	True	string	Name of MySQL table
Filter Query	$filter		string	An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).
Top Count	$top		integer	Total number of entries to retrieve (default = all).
Order By	$orderby		string	An ODATA orderBy query for specifying the order of entries.
Select Query	$select		string	Specific fields to retrieve from entries (default = all).

Returns

The outputs of this operation are dynamic.

Definitions

Procedure

Procedure.

Name	Path	Type	Description
Name	Name	string	Procedure name.
DisplayName	DisplayName	string	Procedure display name.

ProceduresList

Represents a list of procedures.

Name	Path	Type	Description
value	value	array of Procedure	List of Procedures.

Table

Represents a table.

Name	Path	Type	Description
Name	Name	string	The name of the table. The name is used at runtime.
DisplayName	DisplayName	string	The display name of the table.

TablesList

Represents a list of tables.

Name	Path	Type	Description
value	value	array of Table	List of Tables