Title:
Allow Comparing Two SharePoint Columns in Workflow Start Conditions
Description:
Currently, Nintex Workflow start conditions allow comparing a SharePoint column against a static value, but they do not support comparing the two different SharePoint columns.
For example, consider a SharePoint list with the following columns:
A common requirement is to start a workflow only when:
Status <> OldStatus
At present, this cannot be configured directly in the workflow start conditions. The available workaround is to create an additional SharePoint Calculated Column that compares the two columns and returns a value such as Yes or No, and then configure the workflow to start based on that calculated column.
While this workaround functions correctly, it has several drawbacks:
It requires creating and maintaining an additional SharePoint calculated column.
It adds unnecessary complexity to the SharePoint list design.
It is less intuitive for administrators and workflow designers.
It introduces additional configuration that would not be necessary if column-to-column comparisons were supported directly.
Suggested Enhancement:
Enhance the workflow start conditions to allow comparing one SharePoint column with another SharePoint column.
For example, users should be able to configure conditions such as:
Status = OldStatus
Status <> OldStatus
Column A > Column B
Column A < Column B