
Announcements
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
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.