Running a Data Flow at a specific time

I am attempting to run a Data Flow via a timer e.g. run the Data Flow at 8:00 am every day. I tried doing this using a Custom Expression but I am a bit lost as to how the Executing Time DateTime input should be structured for the Flow to run every day since day/month/year must be specified in a DateTime. Could a wildcard be used for these values? Thanks!

2 Likes

In case anyone is following, I figured it out:

This essentially will create a datetime that will send at 8am either the same or the next day depending on the time. I passed NOW() which will default the datetime UTC but can pass a specific timezone through that. You can also just pass the timezone of the user’s device through session.timeZone as well through the NOW() function.

IF(
  NOW().time.hour > 8,
  UPDATE_MINUTE(
    UPDATE_HOUR(
      ADD_TO_DATETIME(
        NOW(),
        1,
        "day"
      ),
      7
    ),
    60
  ),
  UPDATE_MINUTE(
    UPDATE_HOUR(
      NOW(),
      7
    ),
    60
  )
)
2 Likes