web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / Get date when an colum...
Power Automate
Answered

Get date when an column is modified in a SharePoint list

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

Dears,

I'm trying to create a flow to tell me on which date a specific column in my list was changed. The column is date column
The flow runs successfully and I see that the date is showing on my flow but it's not patching on my list.
The flow goes:
When an existing item is modified
Get changes for an item or file (properties only)
I have an expression on Since:
sub(int(triggerOutputs()?['body/{VersionNumber}']),1)
Condition: Has column ... changed equals true 
                                        and
                 -Columnsname- 
equals -Mydesiredvalue-
If yes:
Current time
Update files properties
Columnsname: Current time

How can I adjust it so the date shows on my Sharepoint list?

Thank you!

Categories:
I have the same question (0)
  • annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @Anonymous  are you updating column with current time or current date and time, do you want to store date and time as separate values? 

  • Verified answer
    Community Power Platform Member Profile Picture
    Microsoft Employee on at

    Hi @annajhaveri,

    I just want to see the date, something like 25-3-2021. The time is not important.

  • Verified answer
    annajhaveri Profile Picture
    8,531 Most Valuable Professional on at

    @Anonymous  you can use below expression in update file properties for the column in which you want to store the date

     

    formatDateTime(utcNow(),'dd-MM-yyyy')

    annajhaveri_0-1616758787006.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Automate

#1
David_MA Profile Picture

David_MA 246 Super User 2026 Season 1

#2
11manish Profile Picture

11manish 176

#3
Haque Profile Picture

Haque 157

Last 30 days Overall leaderboard