cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
ferdsjoseph Frequent Visitor
Frequent Visitor

Re: last time refresh

Thank you @trysodin!  Your idea worked perfectly for me.  My previous solution was working but after the recent switch from DST to PST, it was off by an hour.  This is a much simpler solution.  Thank you!

 

let
    Source = Web.BrowserContents("https://www.timeanddate.com/worldclock/usa/san-francisco"),
    #"Extracted Table From Html" = Html.Table(Source, {{"LastRefresh", "[id*=""qlook""]"}}),
    #"Replaced Value" = Table.ReplaceValue(#"Extracted Table From Html","ST","ST; ",Replacer.ReplaceText,{"LastRefresh"})
in
    #"Replaced Value"