I have a Flow running every three hours which queries a REST endpoint for data then writes that data to an On-prem database. The Flow appears to take anywhere from 1-3 seconds to "fire". I'm worried that records might be missed if they are created during this 1-3 second window.
Trigger: Recurrance, every 3 hours, initiated at 2019-08-13T09:00:00Z
Action1: Get Current Time
Action2: Subtract Time, Current Time minus 3 hours
Action3: HTTP query to REST API, uses Action1 & Action2 outputs to query time range
Example Get Current Times for each run:
How do I ROUND down the Get Current Time action to the nearest hour to protect against this?