cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Advocate II
Advocate II

mysql flow connector can't select rows

With the Get Rows option in "MySql" it shows a list of tables Mysql Table Doesn't exist.jpgbut when flow runs and queries the table  constantly replys table doesn't exist.  

Flow message: The specified item '[sjcAlphaBroderArchive].[products]' is not found.
inner exception: The specified item '[sjcAlphaBroderArchive].[products]' is not found.
clientRequestId: 54cb3f26-cb95-42d5-b16e-e6a165b207b8

 

For a premium connector really not operating like a premium.

2 REPLIES 2
Highlighted
Solution Sage
Solution Sage

Re: mysql flow connector can't select rows

Hi @knoseworthy_sjc ,

Could you please share a screenshot of your flow's configuration?

Please try that action without 'Filter Query' for a try.

If the issue still exist, try to rebuild the connection for a try.

Delete the original connection in Flow>Data>connections, then +New connection.

Capture1.PNG

Best Regards,

Community Support Team _ Zhongys

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Advocate II
Advocate II

Re: mysql flow connector can't select rows

Still getting same error regardless - the db and tables exist as i use it with mysql workbench and my other apps - i was hoping to easily use flow to intergrate other utilities vs writing applications.  Is there any issues known with certain versions of mysql, or AWS RDS, azure mysql etc Flow Errors 2 .png

 

Helpful resources

Announcements
firstImage

Now Live: Power Virtual Agents Community!

We are excited to announce the launch of Power Virtual Agents Community. Check it out now!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Users online (5,603)