Update All Items in SP list with unique values

  • 20 February 2021
  • 2 replies
  • 14 views

Hello,

I am trying to update a column in Sharepoint list with difference of  'Date Created' and "todays Date' on daily basis. 

I made a list from excel sheet and have almost 6000 rows, the flow always update all the rows with same values. 

 


2 replies

Userlevel 5
Badge +13

@SamJ You could just use a calculated value field, to so the difference like below.


 



 

Badge +4
Unfortunately @leighburke's solution won't work as calculated fields only calculate on column creation or item creation/modification.

I'd recommend having a site workflow scheduled to run daily, which queries each item, calculates the date and updates the 'difference' column.

Reply