Avoid Duplicate Email Alerts if the source field value remains same

Like (0) Share

Report

Posted on 3 Nov 2021 19:51:21 by KD321

Hi,

We created an excel file in share point which updates every hour and a power flow based on this excel file which sends emails on a condition.

Example : max value ( field from excel file) is greater than 1.2.

On the first hour run if the max value is 1.3 we get alert email automatically and on the second hour run if the remains same 1.3 it should not send an email again unless the value increases or decreases compared to previous run value.

Help me to setup this condition.

Thanks

I have the same question (0)

All responses (1)

Answers (0)

AnthonyAmador 2,553 Moderator on 05 Nov 2021 at 16:18:13

Like (0)

Report

Re: Avoid Duplicate Email Alerts if the source field value remains same

Hi @KD321

The problem here is that you need to access the last row and the row before that to do a comparison.

I think the best way would be to create a duplicated list or table, and update that table only if the added value in the original table is different from the last added in the duplicate table, that way you can make a comparison condition based on the last value and the old value.

Hope this helps.
Kind regards.
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Was this reply helpful? Yes No