Answered

Deadlines Flow - Notify Once

(0) Share

Report

Posted on by NR2023

Hi All,

I've recently built a flow for deadlines which I want to use so that we get a email notification when one of our alerts is less than 60 days old. I've already built the flow which works well but the issue I have is that I am using recurrance for the flow to run every Monday which means the same alerts are sent every week.

What can I do to prevent this so that we only get 1 alert?

This is how my flow is set up.

The spreadsheet file only contains two headers - Alert and Deadline

Screenshot 2023-0...

All responses (4)

Answers (1)

NR2023 28 on at

Like (0)

Report

Re: Deadlines Flow - Notify Once

Thanks so much for your help! Just tested it and works perfectly.
Verified answer

Pstork1 67,060 Most Valuable Professional on at

Like (1)

Report

Re: Deadlines Flow - Notify Once

Add a column to the table in Excel Like this

Then use a condition like this

And if you send the alert update the row like this.
NR2023 28 on at

Like (0)

Report

Re: Deadlines Flow - Notify Once

Thanks for that, I don't suppose you would happen to have any examples I can use to make that happen?
Pstork1 67,060 Most Valuable Professional on at

Like (0)

Report

Re: Deadlines Flow - Notify Once

If you want to send the alert only once then you need to record in the data source that the alert was sent so it doesn't get resent when the flow triggers again. The only other way to do it is to check the due date more specifically that it is due less than 60 days but more than 60 days minus how often you are triggering the flow. So if you are triggering the flow weekly then you only send alerts for due dates that are between 54 and 60 days. Its much easier just to record that the alert was sent and then no resend it if it was.