track of a rather large list on SharePoint

[Gabi]

What I need to do is keep track of a rather large list on SharePoint, when a user makes a change to a value in a particular column the new value should be displayed along with a Y to denote the item has changed. e.g old value Z000 new value Z001 , Y.

Is there a way to implement this?

Thanks

[kkurni]

Basically, it can be done something like this.

Unfortunately, at this moment, there is no way to detect if something is modified just for that particular field.

It is already in feature request list.

But if every modified list, you want to update the value to 'Y', then this flow should work for you.

Thanks

[Gabi]

I've created new list with same values/fields that initial list.
I've created Flow to create item in new list every time that first list is updated manually by user
In new list i have old values & new values, the problem is in calculated fields from first list, the result with flow is empty but the result with SP Designer is the data.
Creating new items, in the new list, by SPDesigner was the solution.

At this moment Flow is good solution but SPDesigner is better in some cases similar to this.

thanks