Unanswered

timestamp when changing field

(1) Share

Report

Posted on by joel914823

557

trying to time stamp the current time into the Resolved Date field (Datacardvalue1) when the Status field (datacardvalue30) changes to 'Resolved' or 'Resolved - No Call Needed'

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

Ajlan 235 on at

Like (1)

Report
timestamp when changing field

Hello,

Steps:

Set the OnChange property of the DatacardValue30 (Status field) to check for the status change and update the Resolved Date accordingly.

Use the If condition to check if the Status field has changed to 'Resolved' or 'Resolved - No Call Needed'. If true, set the Resolved Date to the current time.

Here is the formula you can use for the OnChange property of DatacardValue30:

If(
Or(
DatacardValue30.Selected.Value = "Resolved",
DatacardValue30.Selected.Value = "Resolved - No Call Needed"
),
Patch(
YourDataSource,
ThisItem,
{ ResolvedDate: Now() }
)
)

Cheers 🎉

Was this reply helpful? Yes No
Verified answer

timl 36,319 Super User 2025 Season 2 on at

Like (2)

Report
timestamp when changing field

Hi @joel914823

On way to do this is to set the Default property of your Resolved Date control to this:

If( Or( DatacardValue30.Selected.Value = "Resolved", DatacardValue30.Selected.Value = "Resolved - No Call Needed" ), Now() )

Next, set the OnChange property of your status dropdown to this:

Reset(Datacardvalue1)

This should then reset the date when the dropdown changes.

Was this reply helpful? Yes No
joel914823 557 on at

Like (0)

Report

timestamp when changing field

Hello timl,

Is there a way that it just captures the time and not reset it - I tried to omit the part where it resets but seems that when we change the status - it then clears out the field back to blank.

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

Like (1)

Report

timestamp when changing field

Hi @joel914823

I'm not sure what you mean by this. Can you clarify?

Are you saying that once the Resolved Date value is set by choosing Resolved or 'Resolved - No Call Needed', subsequently changing the value in the dropdown should not change the value in Resolved Date?

Was this reply helpful? Yes No
joel914823 557 on at

Like (0)

Report

timestamp when changing field

Hello timl,

That is correct. If update the status to Resolved - it should capture the current time.

If later the status is then updated to "Not Started" the resolved date field should still show the time captured previously and not clear out or go blank.

Was this reply helpful? Yes No
joel914823 557 on at

Like (0)

Report

timestamp when changing field

timl any help on this would be greatly appreciated.

Was this reply helpful? Yes No
Suggested answer

timl 36,319 Super User 2025 Season 2 on at

Like (1)

Report
timestamp when changing field

Hi @joel914823

Apologies for the delay in getting back to your last question.

To resolve this, you can set the OnChange property of your status dropdown to this:

If(Datacardvalue1.Text = "", Reset(Datacardvalue1) )

By doing this, it won't be reset if there's already a value.

Was this reply helpful? Yes No