Flow to auto populate today's date when status set to completed

%3CLINGO-SUB%20id%3D%22lingo-sub-1005863%22%20slang%3D%22en-US%22%3EFlow%20to%20auto%20populate%20today's%20date%20when%20status%20set%20to%20completed%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1005863%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20imagined%20this%20would%20be%20a%20fairly%20easy%20flow%20to%20write%20however%20as%20I'm%20still%20new%20to%20writing%20Flows%2C%20I'm%20struggling%20more%20then%20I%20thought%20I%20would%20with%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20SharePoint%20list%20which%20is%20for%20recording%20issues%20that%20we've%20found%20within%20a%20department%20and%20I'd%20like%20to%20be%20able%20to%20provide%20metrics%20that'll%20show%20the%20average%20time%20it%20takes%20to%20resolve%20them.%26nbsp%3B%20To%20try%20and%20do%20this%20I've%20added%20a%20'Date%20Completed'%20field%20within%20the%20list%2C%20but%20would%20like%20it%20to%20be%20automatically%20populated%20when%20someone%20changes%20the%20'Status'%20field%20for%20that%20record%20to%20'Completed'.%20At%20the%20moment%20we%20can%20obviously%20manually%20enter%20the%20date%20however%20it'll%20be%20a%20nicer%20solution%20to%20have%20the%20date%20auto-populate.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELooking%20over%20the%20web%20at%20this%2C%20I%20can%20only%20find%20ways%20of%20doing%20this%20through%20SharePoint%20designer%20however%20I'd%20like%20to%20do%20it%20through%20a%20flow%20as%20I%20don't%20have%20designer.%26nbsp%3B%20I%20had%20a%20little%20success%2C%20however%20it%20had%20an%20impact%20on%20a%20separate%20flow%20that%20is%20being%20used%20on%20the%20same%20list%20which%20just%20fills%20in%20today's%20date%20on%20every%20record%20so%20that%20it%20can%20be%20used%20to%20calculate%20how%20long%20that%20record%20has%20been%20open%20for.%3C%2FP%3E%3CP%3EThe%20only%20other%20option%20I've%20come%20across%20is%20to%20use%20a%20calculated%20field%2C%20but%20some%20have%20recommended%20against%20this%20as%20any%20adjustments%20to%20a%20record%20will%20cause%20the%20completed%20date%20field%20to%20updated%20and%20affect%20the%20results.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20any%20additional%20information%20would%20help%20please%20let%20me%20know%2C%20but%20equally%20any%20help%20on%20this%20matter%20will%20be%20greatly%20appreciated.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMany%20thanks%20in%20advance%2C%3C%2FP%3E%3CP%3ERichard%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1005863%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Flow%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20List%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi all,

 

I imagined this would be a fairly easy flow to write however as I'm still new to writing Flows, I'm struggling more then I thought I would with it. 

 

I have a SharePoint list which is for recording issues that we've found within a department and I'd like to be able to provide metrics that'll show the average time it takes to resolve them.  To try and do this I've added a 'Date Completed' field within the list, but would like it to be automatically populated when someone changes the 'Status' field for that record to 'Completed'. At the moment we can obviously manually enter the date however it'll be a nicer solution to have the date auto-populate. 

 

Looking over the web at this, I can only find ways of doing this through SharePoint designer however I'd like to do it through a flow as I don't have designer.  I had a little success, however it had an impact on a separate flow that is being used on the same list which just fills in today's date on every record so that it can be used to calculate how long that record has been open for.

The only other option I've come across is to use a calculated field, but some have recommended against this as any adjustments to a record will cause the completed date field to updated and affect the results.

 

If any additional information would help please let me know, but equally any help on this matter will be greatly appreciated.

 

Many thanks in advance,

Richard

1 Reply
When item is changed you can check if Closed is Yeas and if closed date is NULL, and if so ,write a closed date … and/or write number of days in decimal...