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 / Flow Running Over 8 ho...
Power Automate
Answered

Flow Running Over 8 hours, No Results

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

screencapture-emea-flow-microsoft-manage-environments-Default-3a06f8bf-1cc8-4f60-9869-123f31ff0411-flows-70712e84-41a8-4215-8a21-ee9bcdf35337-2019-11-02-16_21_14.png

 

I have the above flow. It has been running 8 hours now without any results. Any help in solving this would be highly appreciated. 

 

EDIT: This is where the error occurs

 

Capture.JPG

Categories:
  • AKRogers Profile Picture
    354 on at

    Hi @Anonymous,

     

    What stage is it stuck in?  Please click into the run instance that is still running and screenshot which stages have succeeded (green check mark) and which stage is still running (Yellow circle).  

     

    Thank you!

    Ashley

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hello @AKRogers , 

     

    I have edited the question and added the image. Thank you!

  • AKRogers Profile Picture
    354 on at

    Thanks!  

    Can you show us that Delay until action?  You have each row item "delaying until 2,"  which if you've set that to delay until, say, 2pm...that means that each row is going to hang in limbo until 2pm every day.  This is just an example, but if you started the Flow instance after 2pm on day 1 it's going to wait in that Apply to each stage until 2pm the following day.  If you have 31 rows, this is going to take a month to complete.

     

    You may have meant to simply delay each row for 2 minutes, which is actually done via the Delay action and not the delay until action.

    6.png

    Ashley

     

    If this response provided an answer to your question please mark it as a solution so that others can find it.

    If you found this helpful, consider giving it a thumbs up!

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    I am using this function;

    addDays('1900-01-01T00:00:00Z',int(item()?['First Contact']))

    Since Excel Online returns a date as the number of days between the day and 1/1/1900, I use this function to translate what's being returned from the excel into a date. It worked before when I tested it without the conditions.  

  • v-litu-msft Profile Picture
    Microsoft Employee on at

    Hi @Anonymous,

     

    I think the issue is caused by the Delay Until action, cause each branch of the Apply to each action perform should previous branch end, so each Do until action will make the each branch run spend more time.

    What's the reason for you should add the Delay Until at the middle of the process?

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

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @v-litu-msft ,


    Thank you for your reply. 


    I am creating an email automation system that will send out emails based on pre-scheduled dates. So I am using the Delay Until condition to delay sending the email until the relevant date is reached. 

  • AKRogers Profile Picture
    354 on at

    @Anonymous, If you're using the delay until action specifically to wait until a particular date/time to send an email, that is what is holding up the rest of your Flow.  Subsequent actions will not execute while the Delay Until is waiting for that date/time to occur.

  • Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @AKRogers , 

     

    Shouldn't it work for today's date? If not, how should I go about this? I am out of ideas. 

  • AKRogers Profile Picture
    354 on at

    When you have a loop running like that it's difficult to tell where the failed items are and what's been happening while you're waiting for everything to complete.  You mentioned that this worked out for you before you added in the conditions; can you do a test run where you only have one item-- therefore, only one iteration-- and make it so that the "delay until" calculation equals today?  

     

    If your actions don't fire off as expected, put your delay until time  in UTC.  So, if you want it to fire off 5 minutes from now, put your time into UTC time for the test run.  

     

    Let us know!

    Ashley

  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Using @AKRogers suggestion, I broke down the flow and discovered that the condition I was using to calculate the number of days between two days is what was bringing the error. Excel Online returns a date as a number in String form. I solved it by using int() as in this post.

    https://parserr.com/support/knowledge-base/how-to-convert-a-string-to-a-number-in-microsoft-flow/

    Thank you so much @AKRogers and @v-litu-msft  for your help.

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 Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Automate

#1
11manish Profile Picture

11manish 307 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 289

#3
Henil Profile Picture

Henil 127

Last 30 days Overall leaderboard