Answered

Working with a time field that is text (Forms -> SharePoint)

(0) Share

Report

Posted on by Rob_CTL

Hi,

Bit of a challenge today, I am trying to find a way to deal with a limitation of Microsoft Forms in that it doesn't have a "Time" control. At the moment I have two text controls on the form "Start Time" and "End Time", here users input the time they started/finished a job in the format 11:00 (they are using 24H clock so I don't have to worry about AM/PM). The start/end times are always within the same day so no issues with trying to combine two days.

What I am trying to achieve is to calculate the amount of time between the two time fields using Flow then push this result into a Number column within SharePoint.

Any thoughts gratefully received.

Cheers

Rob

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (1)

Sort by

Verified answer

Mira Ghaly 11,415 Moderator on at

Like (1)

Report
Copy link

Link copied!

@Rob_CTL
1. you need to convert the start and end times to an Integer using a an expression details as below

I initialized 2 variables you can replace with your variables from the form
New Int Variable as below :int(split(variables('Start'),':')[0]), repeat the same for End

Then use the the subtract expression as below to get the difference as below:
sub(variables('EndInt'),variables('StartInt'))
If this post helps you with your problem, please mark your as Accepted solution.
If you like my response, please give it a Thumbs Up.
MG (Naturally Curious)

Was this reply helpful? Yes No
Rob_CTL on at

Like (1)

Report
Copy link

Link copied!

@Mira_Ghaly thanks for the reply, I managed to use SharePoint calculated columns to do the transformation but I like your solution so I'll keep that in my tool box for next time.

Was this reply helpful? Yes No