Forum Discussion
Naligurtan
Mar 09, 2023Brass Contributor
Stamp a new date every time status options is changed
Hello All, I have a SharePoint Online list with the following columns: Supplier Name: Text column Supplier Status: In progress, completed, approved, rejected etc. Status Date: a date co...
ganeshsanap
Mar 09, 2023MVP
Naligurtan Try this:
- Create a Power automate flow with "When an item is created or modified trigger".
- Use "Get changes for an item or file" action to get the changes since last "Trigger Window Start Token"
- Check if Has Changed: Status column using condition
- Use "Update item" action inside "If yes" block to update date column to current date using expression utcNow()
Example:
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.
For SharePoint/Power Platform blogs, visit: Ganesh Sanap Blogs