web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / ForEach cycles forever
Power Automate
Suggested Answer

ForEach cycles forever

(0) ShareShare
ReportReport
Posted on by 2
Help! 
 
I'm trying to create an Excel File with a row for each instance of largely recurring events. Yesterday, a flow I built worked just fine - it's pretty simple. A ForEach grabs all the events from a daterange from a calendar (February), then puts them into a table in an Excel file in a SharePoint site, with table columns for Subject, Start Time, End Time, and Location. Cut and dry!
 
But then today I cleared the table, ran it again, to show a colleague the process (so we could move on to step two) and...nothing. The ForEach spins and spins and spins and does nothing.  It seems to have grabbed the data properly, I can see it in the Input from the ForEach, but then nothing in the Add a row into a Table. I'm wondering if it's a Power Automate thing, or if there's some goofy permissions thing somewhere in Microsoft. 
 
Here's the flow, in all its glory.  
 
 
Thanks for any and all help! 
I have the same question (0)
  • Suggested answer
    David_MA Profile Picture
    14,956 Super User 2026 Season 1 on at
    If it doesn't finish, it will eventually time out after an hour and the flow will fail. When it does, post the error message as that will help to figure out the problem. Processing 62 items doesn't seem like it should take that long though. Can you show the configuration of the add a row into a table action. That might offer a clue as to the issue. Right now, there is not enough information to accurately predict the problem.
  • JE-04021855-0 Profile Picture
    2 on at
    Hi! After ?14 Hours, apparently? it timed out. Seems like each instance of the For Each took ~12-15 minutes before it gave up. "Action 'Add_a_row_into_a_table' failed: BadGateway." Error 504. 
     
    Here's the configuration of the Add A Row action: 
     
     
    Let me know if that helps, or if you need more information!
     
     

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.

Helpful resources

Quick Links

Season of Sharing Community Challenge Launch!

Jump in, show your community spirit, and win prizes!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Valantis Profile Picture

Valantis 377

#2
11manish Profile Picture

11manish 279

#3
David_MA Profile Picture

David_MA 234 Super User 2026 Season 1

Last 30 days Overall leaderboard