Forum Discussion
Auto Populate date in a microsoft list column based off an action in another column
Hello
I am attempting to improve a action list we have created. The improvement is adding a "date completed" column to each action. Is there a way to auto populate the "date complete" column when status of the action is change to "completed"? We can see the version history but would like this auto populated.
3 Replies
Hi E2020049, you can use a Power Automate flow with a SharePoint item update trigger. Then, using a condition, if the status is ‘Completed’, change the ‘Date Complete’ column to the current date.
Another option is to add a button using column formatting with the following code. After clicking, the status and date will be changed.
{"elmType": "button","txtContent": "Complete Task","customRowAction": {"action": "setValue","actionInput": {"Status": "Completed","DateComplete": "@now"}}}Hi thank you for the response. However I am still not following...
Could you explain with exact step by step power automate triggers needed?
Hi E2020049 in case when you would like to use Power Automate flow then you can check this article how to detect column change on SharePoint item. https://powercloudtechnologies.com/trigger-power-automate-flow-when-a-column-is-modified/ . Then use the Update item action to update the second column.
The second described method was to use the column formatting directly on the SharePoint list so you would be able to change both columns simultaneously.
