Forum Discussion
Forms: Time input question
This feature is standard with google forms. I would like to keep everything under the Microsoft umbrella but not being able to specify time in a form is a big deal in my case. Hopefully this feature is added soon!
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.
- Scott CooperAug 08, 2018Copper Contributor
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 PennyAug 08, 2018Copper Contributor
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.- KiBangerDec 29, 2020Copper Contributor
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
- Kara PennyAug 06, 2018Copper Contributor
Can I ask what your current workaround is? I have a Flow dependent on the date responses in a Form that I need to get working as soon as possible.
- Randy HerreraAug 06, 2018Copper Contributor
Best work around is google forms. Not the best answer, but I don't bother with Microsoft's option anymore.
- CHRISTIAN CLAMMEAug 06, 2018Copper Contributor
Randy Herrera is right. that is my work around as well (google Forms) until MS can implement this basic functionality.