SharePoint Lesson #48 Old Values - new Values

As soon as you change a value in a data set, the old value is not available any more.

This solution shows a workaround with an auxiliary table and 2 workflows. Determine if the new value is larger, smaller, or equal to the previous value.

In addition you can track the difference between the old and new value.

New value compared to old value

How can you determine how the newly entered value has changed?

Is it larger, smaller or equal than before?

This example uses a Main List and a Secondary List.

All Actions are controlled by 2 workflows.

Secondary/auxiliary List

Felder der Hilfsliste

Main List

Felder der Hauptliste

the Main List

Only when a New Item is created!

Executed if a new record has been entered to the main list.

An New Item is created in the Secondary List:

The Workflow checks how the new value has changed compared to the previous value.

Modifying an existing value.

The initial value [Value],[Title] and [ID] are handed over to the secondary list.

...and this is the Workflow:

After the first workflow has determined the difference between the old and new value, the second workflow sets the new value in the secondary list.