Workflow is a CRM.
Customers can purchase more than one product over time. So I created a drop down column with each value (product) so can look at just the field and see their purchase history. So far so good.
Then when I want to update that field using Zapier, it wipes out any prior values and replaces with the current one. Even if the values are already created in Monday.
For example if a customer purchased product A in 2019 the zap would add that value to the drop down field. However if that same customers purchase Product B in 2020, the Zap will overwrite the Product A value in the drop down column and replace with Product B.