Forum Discussion

John Gruber's avatar
John Gruber
Brass Contributor
Oct 09, 2018
Solved

Set Hour in Microsoft Flow

How do you set the hour in Microsoft Flow? For example, I'd like the flow to save the date/time of tomorrow at 9:00 AM in an Excel row. I found addDays(utcNow(),1) but I'm not seeing an equivalent to JavaScript's setHours function for date/time variables in Microsoft Flow.

  • You can convert the date to a ISO string and rewrite the date manually:

     

    concat(formatDateTime(addDays(utcNow(),1),'yyyy-MM-ddT'), '09:00:00Z')

     

  • John Gruber's avatar
    John Gruber
    Brass Contributor

    You can convert the date to a ISO string and rewrite the date manually:

     

    concat(formatDateTime(addDays(utcNow(),1),'yyyy-MM-ddT'), '09:00:00Z')

     

Resources