Avoid repetition for Excel rows already actioned

[poweraut0mate]

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!

[Pstork1]

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'

[poweraut0mate]

@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: 

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

[Pstork1]

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()