Ran Flow and Emails Created But Process is still Running

[LynneHud]

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!

[Nived_Nambiar · Accepted solution]

Hi @LynneHud 

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

Remove that and try it running again 🙂

Hope this helps 🙂

[MichaelAnnis · Accepted solution]

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]

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.