How to store the date of a status change in a sharepoint list (drop down list, manually updated by user)

[bnsbcn]

Hello,

I am working on a sharepoint with flow.

One of the fields is a drop down list with different status (not started, work in progress, delayed, completed). I'd like that when the user updates this field and I'd like the information is stored somewhere (in the same list of in a different file, whatever is easier).

For example, if the user changes the status to "work in progress" on the 1st of October and then changes it to "completed" on the 15th of October, I'd like for these information to be stored somewhere so that I can do statistics on how long it takes to complete the tasks, which statuses are most used etc.

Any idea of how to do this? I don't know where to start...

thank you

Blanca

[manuelstgomes · Accepted solution]

Hi @bnsbcn 

That's a good idea. To keep track of changes, you can have a lot of information to work and make decisions.

SharePoint can help you do this. Try the following. 

You already have a list with the current information like "not started, work in progress," and so on. Now create a new List in SharePoint that is the "Log of changes" (I'm not good at naming stuff, so please find a name that suits you), and you'll have a link to that table.

The log will have the "Status" since the date will be created for you automatically by SharePoint. 

Something like this:

Then all you need to do is, in your Flow, update the "Main List" and create a new row in the "Log List," and you have all the information that you need. If you want to check the changes, filter by the "Main List" item in the "Log List," and you'll get all the changes done. 

Does it make sense?

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Cheers
Manuel

[xiscors]

Hi @manuelstgomes 

This function allows you to search within another list. I have been checking it and it does not allow me to save the dates of the changes made to another list.
it's possible?