SOLVED

Set Hour in Microsoft Flow

Highlighted
Contributor

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.

1 Reply
Highlighted
Solution

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')