Forum Discussion
SharePoint Calculated filed in a list
Hello All, I have a SharePoint Online list which has the following fields. Event Title, Event start date(date), Event End date(date) and Event Confirmed(Yes/No) filed and Conformation date(Ca...
Naligurtan You can do this with power automate flow.
- Create a power automate flow which will run on item creation/update (based on your requirements)
- You can add trigger conditions so that your will not run always or update the date field again and again. Add trigger condition like: Event Confirmed equal to "Yes" AND Conformation date is blank
- Then use "update item" action to update the Conformation date field with current date using utcNow() function
Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.