cancel
Showing results for 
Search instead for 
Did you mean: 
SamJ
Nintex Newbie

Update All Items in SP list with unique values

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. 

 

Labels: (3)
0 Kudos
Reply
2 Replies
leighburke
Nintex Employee
Nintex Employee

Re: Update All Items in SP list with unique values

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

 

leighburke_0-1613949828580.png

 

0 Kudos
Reply
hejones50
Nintex Newbie

Re: Update All Items in SP list with unique values

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.
0 Kudos
Reply