cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

RSS Weather

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. weather flow.png

 

4 REPLIES 4
Highlighted
Helper V
Helper V

Re: RSS Weather

@d7rr,

 

I work in construction and will only be dealing with this query from that point of view.  

You state that you are proposing to send out this email once a day in an active warning period, that sounds great at first as you are not trying to overload them with email.  However what if the warning increased and as you had already sent a message out that day you did not send another one to your customer and their roof blew off.  Would leave you open to an insurance claim from your customer because they stated they only had one email from you during the active period.  and as they had only had this one email the customer did not take the requisite action to stop their roof being torn off.  

I assume your boss is trying to get them to buy services from you to put the necessary systems in place to stop their roof being torn off.  Is it better for them to receive ALL the emails from you in an active warning period and for them to decide what action they need to take with respect to their roof, even if it means that you cannot get to them to stop their roof being torn off.

The idea is great and the question you post is valid but has your boss thought it through with only ONE email.  Or should you consult your insurers first before even using a flow like this.

Regards,

 

Andrew  

 

Highlighted
New Member

Re: RSS Weather

Thanks for the response, Andrew. You bring a good point. I’m trying to figure out ways at this point to control the outgoing information. Maybe control of just the number of emails isn’t the best way of going about it. Another idea I had, but would be much more advanced, would to be able to parse the information from the feed and be able to discern if it’s something new or simply an extension of the same alert. 7 or 8 emails in a day saying the same thing about wind chill, for example, is unneeded redundancy.
Highlighted
Helper V
Helper V

Re: RSS Weather

@d7rr

I belive you are looking at some sort of Artifiial Intelgence (AI) on this as you state "parse the information from the feed and be able to discern if it’s something new or simply an extension of the same" that is way out of my league and I will have to leave that up to others to answer.

Anyway good luck with this one.

Regards,

 

Andrew

 

Highlighted
New Member

Re: RSS Weather

My question is how to parse it in order to get the data inside the cap...   

For example...  I can get PA, using https://alerts.weather.gov/cap/ga.php?x=0 to see id, updated date, title, link...

But I want to get to the information in the CAP.... 

cap:msgType
cap:category
cap:severity

Do I need to use xpath? I have tried and could not get it to work

 

Helpful resources

Announcements
firstImage

Super User Program Update

Three Super User rank tiers have been launched!

firstImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

Top Solution Authors
Top Kudoed Authors
Users online (8,693)