Answered

Get date when an column is modified in a SharePoint list

(0) Share

Report

Posted on by Community Power Pla...

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!

All responses (3)

Answers (2)

Verified answer

annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report
Re: Get date when an column is modified in a SharePoint list

@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')
Verified answer

Community Power Pla... on at

Like (0)

Report

Re: Get date when an column is modified in a SharePoint list

Hi @annajhaveri,

I just want to see the date, something like 25-3-2021. The time is not important.
annajhaveri 8,531 Most Valuable Professional on at

Like (0)

Report

Re: Get date when an column is modified in a SharePoint list

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