Skip to main content
Nintex Community Menu Bar

Update All Items in SP list with unique values

  • February 20, 2021
  • 2 replies
  • 29 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

Forum|alt.badge.img+14
  • Nintex Employee
  • February 21, 2021

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

 

 


hejones50
Forum|alt.badge.img+4
  • Novice
  • February 25, 2021
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.