Showing results for 
Search instead for 
Did you mean: 
Impactful Individual
Impactful Individual

How can I validate a Time before running a flow?

My App has an input field txtDeliveryTime. It is used to input a Time, which is then passed as a parameter to a flow which then updates a Time field in an SQL Table. (datatype: time(0))

A flow recently failed with this error:

We cannot convert the value "56:00:00" to type Time.
     inner exception: We cannot convert the value "56:00:00" to type Time.
clientRequestId: 21144b16-6bd8-4890-945a-c04f7c60ce31

Is there a way I can validate this as a valid time before I run the flow? 

Dual Super User
Dual Super User

I can't give you the specific REGEX expression off the top of my head, but you should be able to validate that the string is in the right format using ISMatch() before you send it as a parameter to flow.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Join me at 365EduCon in Chicago on Sept. 26-30 where I'll be presenting on the Power Platform!

Helpful resources

Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (2,706)