I have a flow that usually works well, but recently it started returning a 504 error on the Excel action 'List rows present in a table' Here’s what I’ve tried so far:
I added a delay, which only works inconsistently.
I set a retry policy on the action (Exponential Interval, Count: 20, Interval: PT10S), but it hasn’t been effective.
I removed and recreated the Excel connection; this worked at first but then stopped functioning.
I tried using the HTTP connector with Graph API to retrieve the rows directly, but I’m encountering a MaxRequestDurationExceeded error.
I checked the Microsoft 365 Admin Center for service health, and I see an issue marked as an incident (screenshot attached).
Since neither image you attached shows your flow, I cannot be sure as to what you're doing. Is this a scheduled flow that retrieves the data and adds more data to the spreadsheet? If so, that means the number of rows in the spreadsheet is increasing over time therefore explaining why it worked before and now it does not. If so, how many rows are now in the spreadsheet? You may need to use paging to get the rows.
If it ends up being pagination, I then recommend posting another question with any specific issues you might encounter.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
4
Share
Report
All responses (
Answers (
