Date stamp upon status change

%3CLINGO-SUB%20id%3D%22lingo-sub-1937816%22%20slang%3D%22en-US%22%3EDate%20stamp%20upon%20status%20change%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1937816%22%20slang%3D%22en-US%22%3EI%20want%20to%20be%20able%20to%20track%20the%20date%20a%20status%20changed%20on%20a%20SharePoint%20list..%20so%20ideally%20when%20someone%20adds%20a%20list%20item%2C%20then%20changes%20the%20status%20of%20the%20item%20to%20%22Ready%22%20in%20this%20example%20(we%20have%20metadata%20with%20status%20options%20to%20apply)%20I%20want%20the%20date%20to%20be%20out%20into%20another%20column%20of%20data.%20Essentially%20this%20date%20will%20signify%20the%20date%20my%20team%20was%20passed%20the%20item%20for%20review...%20This%20has%20proved%20difficult%20as%20we%20only%20have%20the%20created%20date%20of%20modified%20date%20of%20the%20item.%20But%20these%20dates%20dont%20reflect%20the%20date%20it%20was%20set%20as%20%22ready%22%3CBR%20%2F%3E%3CBR%20%2F%3EThanks%3CBR%20%2F%3EChris%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1937816%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1939869%22%20slang%3D%22en-US%22%3ERe%3A%20Date%20stamp%20upon%20status%20change%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1939869%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F884360%22%20target%3D%22_blank%22%3E%40Cwillia43%3C%2FA%3E%26nbsp%3BHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20create%20a%20new%20date%20field%20to%20contain%20the%20date%20for%20when%20the%20status%20was%20changed%20to%20ready.%3CBR%20%2F%3ECreate%20a%20automation%20flow%20with%20Power%20Automate%20that%20looks%20at%20a%20specific%20listitem%20and%20gets%20triggered%20if%20the%20status%20is%20ready.%20Then%20apply%20the%20date%20on%20the%20new%20field.%3CBR%20%2F%3E%3CBR%20%2F%3EYours%20sincerely%2C%3CBR%20%2F%3EAref%20Halmstrand%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor
I want to be able to track the date a status changed on a SharePoint list.. so ideally when someone adds a list item, then changes the status of the item to "Ready" in this example (we have metadata with status options to apply) I want the date to be out into another column of data. Essentially this date will signify the date my team was passed the item for review... This has proved difficult as we only have the created date of modified date of the item. But these dates dont reflect the date it was set as "ready"

Thanks
Chris
3 Replies

@Cwillia43 Hello,

Please create a new date field to contain the date for when the status was changed to ready.
Create a automation flow with Power Automate that looks at a specific listitem and gets triggered if the status is ready. Then apply the date on the new field.

Yours sincerely,
Aref Halmstrand

  @Cwillia43 there is a Laura Rogers blog post that explains how to do what @ArefHalmstrand describes at https://wonderlaura.com/2020/08/25/flow-when-a-sharepoint-column-is-updated/comment-page-1/ but make sure you don't just copy her sub expression in point 4 as the apostrophes will be copied over incorrectly; put your own apostrophes in from the keyboard.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User

Yeah, that post is great. :)