Answered

TimeDate Field AM PM Hour Changing to First Item on Reopening

(0) Share

Report

Posted on by IntraAdmin

Good morning.

I have a SharePoint Integrated form with a datetime field where I followed these instructions with a full understanding of how it works:

https://www.practicalpowerapps.com/data/time12hour/

When a form is new and the date and time is selected, it submits correctly to the SharePoint list. However, when reopening the item, the hour defaults to the first value in the Hour Items property. We would like for the default to be "99", if time is not known.

My values in the item column are

["99","01","02","03","04","05","06","07","08","09","10","11","12"]
 
Even when keeping everything as in the Practical Powerapps link above (and other instruction I have found on this subject), the hourdatacardvalue still changes to the first item when opening in view then edit.  I am trying to figure out how in the Default property of the hourdatacardvalue, there could be an else ThisItem.Hour(TimeDateColumnName).
 
Any assistance is so much appreciated.

Categories:

Building Power Apps

GCC, GCCH, DoD - Federal App Makers (FAM)

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Haque 4,004 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @IntraAdmin,

Please check if the time value exists in the item - if the time is not set or blank, default to "99". If the time exists, extract the hour part and set it as default.

If( IsBlank(ThisItem.TimeDateColName), "99", Text(Hour(ThisItem.TimeDateColName), "[$-en-US]00") )

Please note that TimeDateColName is the SP column you are working with.

I am sure some clues I tried to give. If these clues help to resolve the issue brought you by here, please don't forget to check the box Does this answer your question? At the same time, I am pretty sure you have liked the response!

Was this reply helpful? Yes No
Suggested answer

11manish 3,849 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
you can also try below :

If( IsBlank(Parent.Default), "99", Text(Hour(Parent.Default), "00") )

1 people found this reply helpful.

Was this reply helpful? Yes No
Verified answer

IntraAdmin 94 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, @Haque.

You definitely put me on the right track. The following is what worked and was thoroughly tested. I am so grateful for your quick feedback.

If(

IsBlank(ThisItem.IncidentDate),

"99",

With(

{

_Hour: Mod(

Hour(Parent.Default),

12

)

},

Text(

If(

_Hour = 0,

12,

_Hour

),

"[$-en-US]00"

)

)

)

Was this reply helpful? Yes No