Update All Items in SP list with unique values

[SamJ]

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. 

[leighburke]

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

[hejones50]

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.