SOLVED

Set Hour in Microsoft Flow

Brass 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
best response confirmed by John Gruber (Brass Contributor)
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')

 

1 best response

Accepted Solutions
best response confirmed by John Gruber (Brass Contributor)
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')

 

View solution in original post