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

Auto update in MS lists

Hi,  I'm new to MS Lists & Sharepoint so I apologies if this is a simple fix. I've created a column in MS Lists which lets me know when a task is overdue and works well but... Is there a way that this 'days overdue' column updates automatically when I log in to MS Lists, or even a one touch refresh,  at the moment it will only update if I edit that section which is time consuming going through each task & really pointless to have it.

I believe I have to create a flow, but haven't a clue how to create one.

 

 

 
 

 

 

 

3 REPLIES 3
manuelstgomes
Community Champion
Community Champion

HI @petern19 

 

How are you checking if it's overdue? Is it a calculated field?

 

I would create a calculated field with the following formula:

 

=IF([Test Date]<TODAY(),"Elapsed","On Time")

 

 

In this case, my column is named "Test Date". Here's the result:

Screenshot 2021-03-04 at 08.48.51.png

 

Can you please check if and let me know if you have any questions?

 

Cheers
Manuel

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

Thanks Manuel,

 

This is the formula I'm using,( below) would yours update every time I log in, or would I have to do manually for each task? I'm really after an automatic update each time I log in rather than changing each task every day. Someone suggested I create a 'flow' but have no idea how.  If I can't find a solution, then I may use your formula as at least I don't have to update each task every day.

=IF(LEN([Est Completion date])=0,0,IF([Est Completion date]<TODAY(),DATEDIF([Est Completion date],TODAY(),"d"),"-"&DATEDIF(TODAY(),[Est Completion date],"d")))

Kinson
New Member

hi, do you have a solution to that? i have similar problem faced today.... while applying  TODAY function, finding sharepoint will not auto refresh the datedif value... poor..

Helpful resources

Announcements
Power Automate News & Announcements

Power Automate News & Announcements

Keep up to date with current events and community announcements in the Power Automate community.

Power Automate Community Blog

Power Automate Community Blog

Check out the latest Community Blog from the community!

Users online (5,148)