web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Calculated date and ti...
Power Apps
Unanswered

Calculated date and time based on choice column gets overridden everytime its opened

(0) ShareShare
ReportReport
Posted on by 124

i have a date and time field which records the start date and end date based on what user selects from the choice field (Scheduled, In Progress(Start) and Closed (End)). My problem is that when user selects in progress and saves the record the date and time is saved but when someone opens the record in model driven the date and time field is overriden and records the currect time even though the user didnt click the save button. I have tried power automate aswell with if conditions which also encounters the same problem. i want the field to be locked and not be overridden everytime user opens the records

Sean9_0-1700154324241.png

 

I have the same question (0)
  • Verified answer
    Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @Sean9 ,

    How are these fields defined?  Are they setup as formula fields or calculated fields?  If you don't want these fields to change unless the value of the status changes then I would suggest you utilize a Power Automate flow or Real Time classic workflow to set these field values only when that status field changes vs having them be a calculated or powerfx formula field.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard