I have a list workflow where I have a column called "column change"
I have a 3 separate workflows that have conditional workflows on modify
WF1- If Column called First Name changes then update column called "column change" to "First Name"
WF2- If Column called Last Name changes then update column called "column change" to "First Name;Last Name" assuming First Name also changed
WF3- If Column called Fitness Test changes then update column called "column change" to "First Name;Last Name,Fitness Test" assuming First Name and Last Name also changed
However, when I attempt to run the 3 workflows only 1 value will display even in cases where all 3 columns have changed.
Workflows
At the Start of WF 1 I clear the column called "column change" and then set the value to "First Name"
At the start of the WF 2 I save the existing value value found in the column called "column change" to a variable. In the Set Value I indicate to update the field to the variable and Last Name varCol Change & " " & "Last Name"
At the start of the WF 3 I save the existing value value found in the column called "column change" to a variable. In the Set Value I indicate to update the field to the variable and Last Name varCol Change & " " & "Fitness Test"
How do I achieve the column called "column change" to reflect all column names (First, Last, and Fitness Test) if all columns actually have changed...Note the conditional WF works in that the comparsion of previous vs current detects if a column has changed, I just cant figure out how to update the "column change" column to reflect what essentially the conditional workflow found.
Desired Results
End Result if all 3 columns change
Column Change should display
First Name;Last Name;Fitness Test (note not the value of the column, but just the column name should display in this column)
End Result if all 2 columns change
Column Change should display
First Name;Last Name (note not the value of the column, but just the column name should display in this column)
OR
First Name;Fitness Test (note not the value of the column, but just the column name should display in this column)
OR
Last Name Name;Fitness Test (note not the value of the column, but just the column name should display in this column)
End Result if 1 column change
Column Change should display
First Name (note not the value of the column, but just the column name should display in this column)
OR
Last Name (note not the value of the column, but just the column name should display in this column)
OR
Fitness Test (note not the value of the column, but just the column name should display in this column)