cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
poweraut0mate
New Member

Avoid repetition for Excel rows already actioned

Hi all! I've been struggling with this issue for quite some time and not sure how to set it up in my flow. 

I want my flow to pull rows from excel and if the value in one of the columns says "yes" i want it to send emails. It's a scheduled flow so it runs every day at 5PM. What I want to avoid is it sending emails for the same row that said "yes" yesterday without having to change it. 

 

My flow currently checks every excel row, but I just don't know how to avoid this repetition. So far I've been going in manually and changing the "yes" to something else if the emails have already been sent for that row, so that my flow doesn't pick it up, but I'm SURE there is a better way to do this. 

 

Thanks for your help in advance!

3 REPLIES 3
Pstork1
Dual Super User
Dual Super User

There are two obvious possibilities.  

1) have the flow change the column to something other than yes when it sends the email.

2) create a different column that will save the Date/Time when the row was processed.  Filter the rows with that before checking to see if they are 'yes'



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
poweraut0mate
New Member

@Pstork1 Thanks for the reply! I had tried #1 previously to have it change "yes" to "sent" after the emails had been sent, but I got the following error which prevents it from changing the yeses to a different key word: 

poweraut0mate_0-1623252784258.png

Any way to get around this error? Sorry I'm new to powerautomate, so appreciate your help!

is Sent the name of the column that includes the Yes value?  If so, it looks like you are trying to add another column called Sent, instead of the value 'Sent' in the column.  Either way you can try adding a date column and setting it to UTCNow()



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Users online (5,458)