Get rows Output Value = []

(1) Share

Report

Posted on by Community Power Pla...

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.

All responses (1)

Answers (0)

alex88 6 on at

Like (1)

Report

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!