Answered

Issues running an SQL flow toward Sharepoint online

(0) Share

Report

Posted on by bolandre92

I have created a simple flow: (1. SQL - when an item is created V2 and 2. Sharepoint - create item). I am planning to insert those rows created from an SQL table into a Sharepoint online list. I tested the flow with the Power Automate feature and it works perfectly. I takes a random item (from the SQL table) and insert it into the Sharepoint online list within a few seconds. Nonetheless, when I leave the flow running alone, it does not work. For instance, I have created a new record in the underlying table from SQL query, from Access, from a trigger in SQL and also from the user interface of the ERP and it does not flow into Sharepoint.

I have reviewed all the connections and they are well set up.

Any help from those that have already experienced and solved this issue is greatly appreciate it.

Thank you

All responses (2)

Answers (1)

bolandre92 73 on at

Like (0)

Report

Re: Issues running an SQL flow toward Sharepoint online

Thank you Alice for reaching out. I have solved this.

For those with the same problem, I have created a new column in my SQL table. I named it as ROWID and then the trigger is working.

Thank you.
Verified answer

v-alzhan-msft on at

Like (0)

Report

Re: Issues running an SQL flow toward Sharepoint online

Hi @bolandre92 ,

Could you please share a screenshot of the configuration of your flow?

Could you please share a run history of the flow when you create a record in the SQL table?

Does the flow run when you create the new record or not?

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.