Share
Report
53Hello All
New to this but trying to figure things out!
I have a MS form that updates a spreadsheet in One Drive whenever the form is completed, from this I've built a table in a separate worksheet that counts how many times an individual is mentioned, an email is then sent to the individuals line manager when the occurrences reach 3 so further interaction can take place, I have created a flow that integrates the worksheet table once a day to check for the value of 3 or greater, and an email is sent if the criteria is met, and all worked well (21 emails sent) however the following day when it re-checked it obviously sent the same 21 individual emails again, which I don't want it to do as the emails had already been sent so I'm trying to figure out a way of the flow knowing which have been sent/dealt with and which haven't (ie only look at things that have changed since last time flow was run if that makes sense)
Any help appreciated
All responses (
Answers (
