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 Automate
Answered

flow times out

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Hi All

I have flow that gets data from few SP lists and converts it to a string. Total lists count is about 500 rows.

For ech of those rows I am checking one column if its null  and also replacing ' with \' (as I am creating Javascript array of objects)

First time I ran it took more than 10 min and just timed out. I am running it again and its alrady taking 16 min.

Is it usual for flow to take that long (its just 500 rows)?

Why it does not finish but times out?

 

Thanks

 

Categories:
I have the same question (0)
  • LeeHarris Profile Picture
    1,026 on at

    Hi @Anonymous 

    Are you able to post screenshots of your entire Flow and what your desired output should be? There may be ways that the overall process can be made more efficient to avoid the lengthy run times.

     

  • Verified answer
    v-yamao-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous ,

     

    Could you share more details on your flow?

     

    I guess that you want to get items from the list, then find out one column if it is null, and replace the column with “\”.

     

    Flow is now able to get 100,000 items if you are using Plan1 and Plan2 license:

    https://docs.microsoft.com/en-us/flow/limits-and-config

     

    I have set up a simple flow likes below for your reference. The function used in the condition is:

     

    empty(items('Apply_to_each')?['Closed'])
    
    is equal to
    
    True

     

    1.PNG

     

    Best regards,

    Mabel

     

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
Haque Profile Picture

Haque 552

#2
Valantis Profile Picture

Valantis 388

#3
11manish Profile Picture

11manish 375

Last 30 days Overall leaderboard