Preventing Data Shuttle workflow from overwriting locked rows

Chris_Motto

I have a process in place to pull data into a sheet, where after a cell is changed pushes out a request for approval to a manager.

When Approved, we are locking the row. When Denied, we'd update the source system data, re-pull via the Data Shuttle workflow and resubmit for approval. However, we're seeing the data in the approved/locked rows overwritten with the data coming from the Data Shuttle workflow.

Is there anyway to prevent only those locked rows from being updated? Or do we need to rethink the process and remove the "Update Rows…" option from our workflow?

Larry

If possible I would recommend creating a Move Row automation to move the "Approved" rows to a separate sheet that holds just the Approved rows & is not impacted by the Data Shuttle workflow. The filter options within Data Shuttle workflows look at the source file NOT the target.