cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bnsbcn
New Member

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

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

1 REPLY 1
manuelstgomes
Super User
Super User

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:

 

small-Screenshot_2019-10-22_at_10_59_11.jpg

 

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

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,400)