Forum Discussion

E2020049

Copper Contributor

Oct 02, 2024

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

microsoft lists

michalkornet

Iron Contributor

Oct 02, 2024

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.

{

"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",

"elmType": "button",

"txtContent": "Complete Task",

"customRowAction": {

"action": "setValue",

"actionInput": {

"Status": "Completed",

"DateComplete": "@now"

}

E2020049
Copper Contributor
Oct 08, 2024
michalkornet

Hi thank you for the response. However I am still not following...

Could you explain with exact step by step power automate triggers needed?
- michalkornet
  Iron Contributor
  Oct 11, 2024
  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.