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

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
Solution Sage
Solution Sage

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.

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.

Top Solution Authors
Users online (15,409)