Forum Discussion

Brass Contributor

Sep 20, 2016

Forms: Time input question

In Office 365 Forms, I am attempting to create an event request form. I do not appear to be able to add a question for TIME of Day. I see a template for DATE but not TIME. In Google Forms "include...

Copper Contributor

Aug 08, 2018

1) just use a generic text box and "hope" they put in something generally recognisable as a time.

2) as 1) but use flow and its connectors to generate an actual time formatted response, its a bit of a ball ache though trying to take into account all the possible variations and typo's to capture everything.

Kara Penny

Copper Contributor

Aug 08, 2018

Hey y'all - I found a good, somewhat simple workaround for this using Concatenate.

The formula I used is:

concat(body('Get_response_details')?['r94ed2d61cbe44edabc32a89af9c1dae0'])

and if you want to add a specific time, modify this using military time:

concat(body('Get_response_details')?['r84e34585ba6749ef939f00bfa331c5ff'],'T17:00:00Z')

Start out using Expression, concat, then switch over to Dynamic and point it to the date response you're looking for.

KiBanger
Copper Contributor
Dec 29, 2020
Kara PennyI was wondering if you could elaborate on this a bit more (more step-by-step). I'm a newbie to this, and I definitely would appreciate it. Thank you!

Ki
Rikelmi Marte
Copper Contributor
Jan 30, 2019
Is this formula created for any given time? for some reason, all events have 5-530 pm
Scott Cooper
Copper Contributor
Aug 08, 2018
......that feeling you get when you've spent hours putting together a flow that kinda works, and someone goes and does it 'properly'....