SOLVED

Updating a list date column

%3CLINGO-SUB%20id%3D%22lingo-sub-1360168%22%20slang%3D%22en-US%22%3EUpdating%20a%20list%20date%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1360168%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20an%20issue%20tracking%20list%20on%20my%20sharepoint%20site%20-%20I%20need%20to%20be%20able%20to%20update%20the%20resolved%20date%20when%20the%20status%20changes%20to%20resolved.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1360168%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-1361340%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20list%20date%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1361340%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F634702%22%20target%3D%22_blank%22%3E%40rbutgins21%3C%2FA%3E%26nbsp%3BYou%20can%20do%20in%20multiple%20ways%20and%20easier%20option%20using%20MS%20Flow%20or%20SharePoint%20Workflow%20on%20updates%20of%20the%20list%20item%20check%20if%20the%20status%20equals%20to%20resolved%20then%20set%20then%20set%20the%20resolved%20date%20column%20to%20today's%20date.%20Just%20make%20sure%20you%20set%20the%20date%20once%20to%20that%20use%20a%20additional%20column%20something%20like%20resolved%20date%20updated%20%3DYes.%20This%20helps%20you%20to%20prevent%20updating%20this%20column%20any%20further%20updates%20to%20the%20column.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20you%20have%20three%20columns%20and%20status%20is%20In%20Progress.%3C%2FP%3E%3CP%3EStatus%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%7C%20Resolved%20Date%20%7C%20Resolved%20Date%20Updated%3C%2FP%3E%3CP%3EIn%20Progress%20%7C%20EMPTY%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%7C%20NO%3C%2FP%3E%3CP%3E------------------------------------------------------------------%3C%2FP%3E%3CP%3EOnce%20the%20status%20is%20changed%20to%20resolved%3C%2FP%3E%3CP%3EStatus%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3B%7C%20Resolved%20Date%20%7C%20Resolved%20Date%20Updated%3C%2FP%3E%3CP%3EIn%20Progress%20%7C%20Today's%20Date%26nbsp%3B%20%26nbsp%3B%7C%20YES%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20when%20you%20are%20checking%20the%20logic%20make%20sure%20check%20Resolved%20Date%20is%20empty%20and%20Resolved%20Date%20Updated%3D%3DNo%20to%20make%20the%20logic%20error%20proof.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20this%20helps.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1361423%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20list%20date%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1361423%22%20slang%3D%22en-US%22%3E%3CP%3EThat%20is%20similar%20to%20what%20I%20was%20trying%2C%20I%20have%20attached%20a%20couple%20of%20screen%20shots%20of%20my%20flow%2C%20am%20I%20going%20down%20the%20correct%20path%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MSFlow1.PNG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F189242iC083DB9D4F9AAC6D%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22MSFlow1.PNG%22%20alt%3D%22MSFlow1.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22MSFlow.PNG%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F189243i20B767719263B27E%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22MSFlow.PNG%22%20alt%3D%22MSFlow.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%E2%80%83%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394813%22%20target%3D%22_blank%22%3E%40Vikram_Samal%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1365319%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20list%20date%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1365319%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20my%20flow%20working%2C%20just%20not%20sure%20how%20to%20load%20the%20current%20date%20into%20the%20Resolved%20Date%20list%20column%20using%20and%20update%20item%20action.%26nbsp%3B%20Any%20suggestions%20would%20be%20greatly%20appreciated!!!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22rbutgins21_0-1588796260122.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F189581i8912A93F83C8FA56%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22rbutgins21_0-1588796260122.png%22%20alt%3D%22rbutgins21_0-1588796260122.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1365668%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20list%20date%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1365668%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F634702%22%20target%3D%22_blank%22%3E%40rbutgins21%3C%2FA%3E%26nbsp%3BYou%20need%20to%20declare%20a%20variable%20and%20set%20the%20value%20in%20that%20something%20like%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_0-1588805844423.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F189629iFBD22BF82A50AD21%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_0-1588805844423.png%22%20alt%3D%22Vikram_Samal_0-1588805844423.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3Ethe%20Expression%20you%20need%20to%20set%20is%20%3A%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%3EformatDateTime(utcNow()%2C'yyyy-MM-dd')%3C%2FPRE%3E%3CP%3Ethen%20set%20the%20variable%20value%20in%20the%20field%20in%20update%20item%20or%20your%20action%3A%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%222020-05-06_1559.png%22%20style%3D%22width%3A%20631px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F189630iEB002F9B954A0B5F%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%222020-05-06_1559.png%22%20alt%3D%222020-05-06_1559.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHope%20this%20helps%20and%20please%20mark%20the%20response%20as%20answer%20if%20it%20resolves%20your%20problem%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1369805%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20list%20date%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1369805%22%20slang%3D%22en-US%22%3E%3CP%3ESomething%20like%20this%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22rbutgins21_0-1588863030276.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F189790iE2EF35526747FC78%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22rbutgins21_0-1588863030276.png%22%20alt%3D%22rbutgins21_0-1588863030276.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1370968%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20list%20date%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1370968%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F634702%22%20target%3D%22_blank%22%3E%40rbutgins21%3C%2FA%3E%26nbsp%3BThe%20first%20part%20is%20correct%20not%20the%20second%20part.%20After%20the%20first%20part%20in%20variable%20%22ResolveDate%22%20today's%20date%20is%20there%2C%20now%20when%20updating%20the%20list%20item%20set%20the%20'Resolved%20Date'%20field%20value%20with%20this%20variable.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Vikram_Samal_0-1588869548445.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F189810i2FFC0E4FD883A5F0%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Vikram_Samal_0-1588869548445.png%22%20alt%3D%22Vikram_Samal_0-1588869548445.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EHope%20this%20helps%20and%20mark%20the%20response%20appropriately%20if%20it%20helps%20in%20this.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1371576%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20list%20date%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1371576%22%20slang%3D%22en-US%22%3E%3CP%3EGot%20it%2C%20thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1371787%22%20slang%3D%22en-US%22%3ERe%3A%20Updating%20a%20list%20date%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1371787%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20for%20your%20help%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F394813%22%20target%3D%22_blank%22%3EVikram_Samal!!%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20marked%20the%20wrong%20message%20as%20the%20best%20response%2C%20couldn't%20have%20done%20it%20without%20you!%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

I am using an issue tracking list on my sharepoint site - I need to be able to update the resolved date when the status changes to resolved.

8 Replies
Highlighted

@rbutgins21 You can do in multiple ways and easier option using MS Flow or SharePoint Workflow on updates of the list item check if the status equals to resolved then set then set the resolved date column to today's date. Just make sure you set the date once to that use a additional column something like resolved date updated =Yes. This helps you to prevent updating this column any further updates to the column.

 

Let you have three columns and status is In Progress.

Status         | Resolved Date | Resolved Date Updated

In Progress | EMPTY             | NO

------------------------------------------------------------------

Once the status is changed to resolved

Status         | Resolved Date | Resolved Date Updated

In Progress | Today's Date   | YES

 

So when you are checking the logic make sure check Resolved Date is empty and Resolved Date Updated==No to make the logic error proof.

 

Hope this helps.

 

Highlighted

That is similar to what I was trying, I have attached a couple of screen shots of my flow, am I going down the correct path? 

MSFlow1.PNG

MSFlow.PNG

  

@Vikram_Samal 

Highlighted

I have my flow working, just not sure how to load the current date into the Resolved Date list column using and update item action.  Any suggestions would be greatly appreciated!!!

 

rbutgins21_0-1588796260122.png

 

Highlighted

@rbutgins21 You need to declare a variable and set the value in that something like this:

Vikram_Samal_0-1588805844423.png

the Expression you need to set is : 

 

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

then set the variable value in the field in update item or your action:

 
 

2020-05-06_1559.png

Hope this helps and please mark the response as answer if it resolves your problem

 
 
 
 
 

 

 

 

 

 

 

 

 

 

Highlighted

Something like this?

rbutgins21_0-1588863030276.png

 

Highlighted

@rbutgins21 The first part is correct not the second part. After the first part in variable "ResolveDate" today's date is there, now when updating the list item set the 'Resolved Date' field value with this variable.

Vikram_Samal_0-1588869548445.png

Hope this helps and mark the response appropriately if it helps in this. 

 

Highlighted
Best Response confirmed by rbutgins21 (Contributor)
Solution

Got it, thanks!

Highlighted

Thanks for your help Vikram_Samal!!

 

I marked the wrong message as the best response, couldn't have done it without you!