Forum Discussion

William Mattison

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...

microsoft forms

Copper Contributor

Jul 12, 2018

I really need this, have a few forms that don't quite give us what we need, without THIS.

having to do a really convoluted workaround which is just nasty.

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

Resources