Unanswered

Avoid repetition for Excel rows already actioned

(0) Share

Report

Posted on by 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!

Categories:

Building flows

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Pstork1 69,657 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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'

Was this reply helpful? Yes No
poweraut0mate 3 on at

Like
a
(0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Pstork1 69,657 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No