Sending email notification that item is delayed; and tracking those emails
I want to build a daily reoccurring flow that will send out email notifications that an item is delayed (when the update required date is less than today's date), but I only want to send a notification for that record once. So on the following day, I dont want to send another notification that the same record is delayed. Thus, I would want to track those email notifcations and check on the 2nd day if the item had already been sent an email notification and if it has, I would want to skip it, otherwise it should send the email notification.
What I need help with is checking to see if there was already an email notification been sent. This is what I have thus far:
Down below is what the RAIL list Looks like:
Down below is some of the information that I would like to collect in the RAIL List - Escalation List:
Here is the rest of the Flow that I have, but I dont think the beginning piece correct, and once I know how to check if a notification email was sent for a particular item, and can implement it, then I should be good to go..
Thank you for the suggestion. I would like to stray away from adding that column to the table, as I have other flows that are tied to the modified date/modified by columns. But if there are no other options, I would do so.