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 / Ran Flow and Emails Cr...
Power Automate
Answered

Ran Flow and Emails Created But Process is still Running

(0) ShareShare
ReportReport
Posted on by 32

Hello!  Please review flow as after emails are created the process continues to run.  The emails are generated based on the Status 'Incomplete'.  Thank you!

LynneHud_0-1682093714157.pngLynneHud_1-1682093794218.pngLynneHud_2-1682093835460.png

 

I have the same question (0)
  • Verified answer
    Nived_Nambiar Profile Picture
    18,138 Super User 2026 Season 1 on at

    Hi @LynneHud 

     

    I think top loop is not need as it will repeat the process inside it that many times it is defined 

    Nived_Nambiar_2-1682094270096.png

     

    Remove that and try it running again 🙂

     

     

     

    Hope this helps 🙂

     

  • Verified answer
    MichaelAnnis Profile Picture
    5,727 Moderator on at

    Your first free row is row 2788 when it should be 11.  First free row is the row after the row you end-up on when you hit Control + End if you were in the Excel file manually.

     

    What this means is that there used to be data down there and someone cleared it, but didn't delete it.

     

    You could try First Free Row on Column, but I doubt it would act differently.  Another option is to do the following to the Excel workbook after it is open:

     

    Select A7

    Send Keys {Control}({Down})

    Get Active Cell (what you really want is get active row, but that might not be possible, and you have to infer it from the active row)

     

    Best of luck!

  • LynneHud Profile Picture
    32 on at

    Thank you!!  I was able to fix the first free row issue by recreating the file with information in rows 1-4 and columns A-E.

     

    After deleting the top loop, I received error messages for 'Send email message through outlook'.  Also, my 'IF' statement is not working.  I wanted to send emails for 'Incomplete' statuses. It is creating email for the 'Complete' status as well.  Please help.

    LynneHud_0-1682460510689.pngLynneHud_1-1682460549181.png

     

    LynneHud_2-1682461001885.png

     

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 607

#2
Valantis Profile Picture

Valantis 456

#3
11manish Profile Picture

11manish 352

Last 30 days Overall leaderboard