Hello,
We are a commercial roofing company. My boss tasked me with finding a way to send weather alerts to customers on a specified list via email. I'm using the NOAA RSS feed here:
https://alerts.weather.gov/cap/wwaatmget.php?x=OHC049&y=0
The problem I'm having is they sometimes update their alerts several times a day. I'm looking for a way to only let the flow send out one email every day...keep in mind, this needs to be triggered by the RSS publishing an update, not a recurrence...I've been thinking about recording the RSS update time and date in a sharepoint excel file and then referencing that date and time, but not sure how to make it come together. Any other ideas and instructions are greatly appreciated too!
The picture is what I have now. It filters any updates with no active warnings based on the RSS title, then sends a formatted email. 