Unanswered

Power Automate and SharePoint Excel file stopped working

(2) Share

Report

Posted on by ckalbfleisch

I have power automate flows that trigger when a power bi dataflow refresh completes. The flow writes some data to an excel file. Another flow periodically reads the data from the excel file and then deletes the row from excel. In otherwords a simple fifo implemented in a table in Excel shared between many sources writting into the file and one consumer. This has worked for the past 4 years or more. Starting a few hours ago, the flows writting to the file started failing with Gateway Timeout. And the flow reading the table is failing with "Action 'List_rows_present_in_a_table' failed: BadGateway"

Anyone else seeing this problem? Is there some issue with SharePoint online and Power Automate? The flows are all running with a Service Account and I can open the Excel file with the service account. So doesn't seem to be a permissions issue.

Any help is greatly appreciated.

Categories:

Building flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

rzaneti 4,483 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

Hi @ckalbfleisch,

During the last few days, I see an increase in the issues with Excel connector reported here in the Community Forum. I'm not sure about what can be happening, and according to some of the authors of these threads, the action just come back to normal after a few days.

Are you experiencing this error with other flows? If not, my recommendations are:

1- Just remove and include again your List rows present in a table action.

2 - If it doesn't work, add a new connection to Excel. You can keep the same service account

3 - If it doesn't work, create a copy of this flow, and try to run it.

After you run these steps, please let me know about the results.

Let me know if it works for you or if you need any additional help!

✅ If this solved your issue, please mark it as Accepted Answer.
👍 If it helped, feel free to give it a like!

🌐 Explore more Power Platform content on my Website or on my ▶️ YouTube
💼 Find me on LinkedIn

Was this reply helpful? Yes No
stampcoin 5,148 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!

@ckalbfleisch Hi,

Have you triggered limitation ?

General known issues and limitations

Have you tried to delay the write action ? if not, add one.

move it to OneDrive for testing.

(Excel is not a robust solution for using like this).

good luck.

Was this reply helpful? Yes No
ckalbfleisch 34 on at

Like (0)

Report
Copy link

Link copied!

@rzaneti - unfortunately even "save as" fails due to the problem with the connector. So I am not able to make a new copy of the flow.

Was this reply helpful? Yes No
ckalbfleisch 34 on at

Like (0)

Report
Copy link

Link copied!

@stampcoin - there are hundreds of flows producing new rows into the excel file. so moving the file to one drive is not really possible as I'd have to edit 100's of flows to handle it.

Was this reply helpful? Yes No
ckalbfleisch 34 on at

Like (1)

Report
Copy link

Link copied!

Along the lines of what rzaneti mentioned, I created a new connection to the Excel in the consumer flow and it seems to be working now.

Was this reply helpful? Yes No
rzaneti 4,483 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi @ckalbfleisch,

It's great to know that it's working fine. If the problem is solved and you don't have any more questions related to the topic, please mark the response as answered :)

Was this reply helpful? Yes No