Converting Text Input to TimeValue

(0) Share

Report

Posted on by Brian-M

437 Super User 2024 Season 1

Having trouble converting text input to TimeValue on form update. On existing records, it display just fine:

But when entering a new record, I get a conversion error:

Field default is "Parent.Default"

DataCard default is "TimeValue(ThisItem.ServiceTime)

Source format is datetime2(7) in SQL

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report

Hi @Brian-M

What's the formula in the Update property of the card? The formula here is the most likely cause of the error.

Because datetime2 is a datatype that expects a date component in addition to the time, I would expect a formula that creates a datetime, perhaps based on the "Appt Date" value. If this is blank (as in the case of your screenshot), this would be a cause of the error.

Was this reply helpful? Yes No
Brian-M 437 Super User 2024 Season 1 on at

Like (0)

Report

@timl , the update field says, "TimeValue4", which is name of the text input field. I also tried:

TimeValue(TimeValue4)

but that didn't prevent the error

Also, this seems odd to me. It looks like TimeValue is converting to Date/Time (as expected) but still getting the error in Live mode:

Was this reply helpful? Yes No
Brian-M 437 Super User 2024 Season 1 on at

Like (0)

Report

I have more information. I tried testing on SQL fields using datatype Time and varchar and I'm still getting the error, so I don't think the issue is the SQL column format. Now I'm just confused.

Was this reply helpful? Yes No
timl 36,383 Super User 2025 Season 2 on at

Like (0)

Report
Hi @Brian-M

I'd try specifically referencing the Text property of the text input control. Perhaps that might work more reliably in Live mode.

TimeValue(TimeValue4.Text)

Was this reply helpful? Yes No
Brian-M 437 Super User 2024 Season 1 on at

Like (0)

Report

Yup, I found that error and corrected it. It now refers to TimeValue4.Text. But still getting same error. I even tried setting the source as both Time and varchar to see if it was the source. Still get the same error. I've tried it with TimeValue, without TimeValue with "Text(TimeValue4.Text, "hh:mm AM/PM"), etc... still receiving the error.

I don't get it. How do you submit something like "10:30 AM" through a form? I can do it through a Gallery without any problems, but not a form.

Was this reply helpful? Yes No
Verified answer

Brian-M 437 Super User 2024 Season 1 on at

Like (0)

Report

After doing a lot of research and testing I've reached two conclusions:

1. When you need to enter a time like "10:30 AM" with SQL, your datatype should be varchar only. There's really no other option as PowerApps doesn't even really play nicely with Time format. Note here though that this ONLY applies to FORMS. Using datatime2 and displaying "10:30 AM" seems to work just fine in a GALLERY. But in a form, it does not work at all

2. Something has happened with my current form that cannot be fixed. Removing and adding back the field I need to use with a Time was the only way to fix the formatting error, even after I changed the source type to varchar.

3. With varchar as your source type, you'll need to use "TimeValue(ThisItem.Time)" as your form field Default to display it properly.

Was this reply helpful? Yes No