The TimeValue function in PowerApps is used to convert a text string that represents a time into a DateTime value. This function is useful when you need to handle time inputs in text format and convert them into a time value that can be used for calculations or display.
PowerApps – TimeValue() function Syntax
- TimeString: A text string that represents a time. This can include hour, minute, and second components, optionally with AM/PM designations.
Notes:
- Invalid Time Strings: Ensure that the time string is in a valid format. Use validation to check if the input string is a valid time before converting.
- Empty Strings: Handle cases where the input string might be empty to avoid errors.
PowerApps – Convert text into time value
To convert the text "3:45 PM" into a time value:
This returns a DateTime value representing 3:45 PM.
- 24-Hour Time Format
To convert a 24-hour formatted time string like "14:30:00" into a time value:
This returns a DateTime value representing 2:30 PM.
- Including Seconds
To convert a time string that includes seconds, such as "08:15:30 AM":
This returns a DateTime value representing 8:15:30 AM.
PowerApps - Calculate the difference in Time Values
You can convert text times into time values to perform calculations. For example, calculating the difference between two times:
DateDiff(TimeValue("2:00 PM"), TimeValue("4:30 PM"), Minutes)
This calculates the difference in minutes between 2:00 PM and 4:30 PM.
PowerApps – Filter Records Based on Time
If you have a table of events with time strings and you want to filter events that occur after a certain time:
Filter(Events, TimeValue(EventTime) > TimeValue("12:00 PM"))
This filters the Events table to include only those events that occur after 12:00 PM.