cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Spawn10
Helper III
Helper III

How do I set a SharePoint list column to today's date

How to I set a SharePoint List column to Today's date? Anytime and item is modified, I want to set a column to today's date.

I have not been able to get this to work.

1 ACCEPTED SOLUTION

Accepted Solutions
Spawn10
Helper III
Helper III

I ended up using this expression "formatDateTime(utcNow(),'yyyy-MM-dd')" when I update the item, and it seems to be working fine. 

View solution in original post

7 REPLIES 7
tom_riha
Super User
Super User

Hello @Spawn10 ,

do you need a separate column for that? There's already default 'Modified' date column in SharePoint that contains the date/time of the last update.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]
Spawn10
Helper III
Helper III

I ended up using this expression "formatDateTime(utcNow(),'yyyy-MM-dd')" when I update the item, and it seems to be working fine. 

Where should I write this formula? When creating a date column?

@tom_riha How do I achieve that? I am defining a separate column for modified dates. When there is a change in any of the values of the column, then I would like the list to take the current date automatic on date column

Hello @Ravi021 ,

if it's about storing the date of last modification then you can use the standard SharePoint "Modified" column. You don't need an extra one.



[ If I have answered your question, please Accept the post as a solution. ]
[ If you like my response, please give it a Thumbs Up. ]

[ I also blog about Power Automate solutions even for non-IT people. ]

I only see a date/time column.  I do not see a default for a 'modified' column.

Where do you insert that expression?

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,026)