cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
JCrumpton
Level: Powered On

Get rows Output Value = []

I have a flow triggered by a recurrence and using the MySQL Get rows action.  It is pulling all records from a view in a MySQL database.  It successfully runs on a nightly basis, but does pull any values.  Instead, it shows a value of [].  If I initiate the flow manually it executes as expected.  Below are screenshots of the relevant parts of the flow and results with the error. Any suggestions on why it fails to execute automatically?

 

Thanks in advance.

Recurrence2.pngRecurrence1.png

1 REPLY 1
alex88
Level: Power Up

Re: Get rows Output Value = []

I don't know if this will be seen but will ask anway:

 

how did you get Flow to connect to MYSQL?

I can't find any guides or information for this online, everything relates to Power BI. I had to install a gateway on my machine when creating the flow, but I still cannot get the MYSQL to connect to Flow - I also don't understand why my local machine creating the flow (doing so on my laptop) needs to have the gateway installed..

 

Very confusing, any help appreciated!

Helpful resources

Announcements
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!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,236)