Unanswered

My closed date changes every time I open ticket details page.

(0) Share

Report

Posted on by Evan_S1

341

I have a date and time that auto populate date, hours, minutes based on when a ticket goes to closed status. The code works and the date auto fills when a ticket is closed. However, when I go back into ticket details it repopulates the date and time to when I open the details page. I need the date and time to stay the date and time of when the status was first closed.

Current codes shown below:

Date:

If(Or(DataCardValue61_1.Selected.Value="Closed"),Today(),Blank())

Hour:

If(Or(DataCardValue61_1.Selected.Value="Closed"),Text(Hour(Now())),Blank())

Minutes:

If(Or(DataCardValue61_1.Selected.Value="Closed"),Text(Minute(Now())),Blank())

Categories:

Building Power Apps

I have the same question (0)

All responses (19)

Answers (0)

Sort by

BCBuizer 22,833 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Evan_S1 ,

You can do this by setting the OnChange property of the DataCardValue in which you select the status to:

If(Self.Selected.Value = "Closed", UpdateContext({locClosedSelectedTime: Now()}))

This saves the time at which Closed is selected in a variable (locCLosedSelectedTime). This variable can then be referenced in the Default( properties of your date/time field:

Date:

locCLosedSelectedTime

Hour:

Hour(locCLosedSelectedTime)

Minutes:

Minute(locCLosedSelectedTime)

Was this reply helpful? Yes No
Anchov 1,986 on at

Like
a
(0)

Report
Copy link

Link copied!
You will need to update your formulas to something like this this (change field name as needed):

If(And(IsBlank(ThisItem.'Closed Date'), DataCardValue61_1.Selected.Value = "Closed"), Today(), ThisItem.'Closed Date')

Rinse and repeat for Hours and Minutes

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

Was this reply helpful? Yes No
Evan_S1 341 on at

Like
a
(0)

Report
Copy link

Link copied!

I am receiving the below error using your formula within the Default of my status datacardvalue.

Was this reply helpful? Yes No
BCBuizer 22,833 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Evan_S1 ,

I seem to have missed a curly brace which I now added to the original post.

Was this reply helpful? Yes No
Evan_S1 341 on at

Like
a
(0)

Report
Copy link

Link copied!

Do I change the below function to what you provided?
Current codes shown below (All in Default):
Date:
If(Or(DataCardValue61_1.Selected.Value="Closed"),Today(),Blank())

Hour:
If(Or(DataCardValue61_1.Selected.Value="Closed"),Text(Hour(Now())),Blank())

Minutes:
If(Or(DataCardValue61_1.Selected.Value="Closed"),Text(Minute(Now())),Blank())

Was this reply helpful? Yes No
BCBuizer 22,833 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Evan_S1 ,

That's correct, you can replace the existing formulas.

Was this reply helpful? Yes No
Evan_S1 341 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok I recv'd a bunch of errors.

Was this reply helpful? Yes No
BCBuizer 22,833 Super User 2026 Season 2 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Evan_S1 ,

Slightly updated versions:

Date:

DateValue(locClosedSelectedTime)

Hour:

Text(Hour(locClosedSelectedTime),"00")

Minutes:

Text(Minute(locClosedSelectedTime),"00")

Was this reply helpful? Yes No
Anchov 1,986 on at

Like
a
(0)

Report
Copy link

Link copied!

If you are trying to use my solution, you would add my code to the DefaultDate property of you Date control, not the Status data card.

Was this reply helpful? Yes No
Evan_S1 341 on at

Like
a
(0)

Report
Copy link

Link copied!

receiving a new error
And just to confirm, i'm changing your (locClosedSelectedTime) with the name of where "closed" is selected?

Was this reply helpful? Yes No