If you are using Azure SQL DB for MySQL Standalone server and upgrading to MySQL Flex server and using Power Automate, you may see an error message from your Power Automate flows if you are using a Data Gateway. The error message that you’re getting could look something like this.
An error happened while reading data from the provider: 'Character set 'utf8mb3' is not supported by .Net Framework.' inner exception: An error happened while reading data from the provider: 'Character set 'utf8mb3' is not supported by .Net Framework.' 
The problem in my case that was causing this issue was an older driver on our data gateway. It seems that for Power Automate to use a data gateway to connect to Azure SQL DB for MySQL, you’ll need a newer MySQL Driver installed on the Data Gateway server. We had 8.0.15 installed, and the error message went away when we upgraded to 8.4.0 (the current version as of this post being written). The annoying part of this is that the database on the flex server and the stand-alone server was exactly the same database. To move the database from the standalone server to the flex server, we simply took a MySQL Dump of the standalone server and imported that into the Flex server. So, everything in the database was the same, but apparently, the connecter didn’t like anything about the new Flex server without a driver upgrade.
Once the driver was upgraded all the flows which use that connector for the MySQL database started working as expected.
Denny
