Hello, I am trying to build a workflow for "Find duplicate from the list b and update choice status to Duplicate item"
We receive work from List A to List B
I work on List B. I created a Choice column called status- and I added choices of New item, Duplicate item, completed, and Under review.
Sometimes we receive duplicate items in List B from List A, I would like to identify those duplicates every time when a new item is added in List B and I want to change the latest duplicate item status to Duplicate item if the manufacturer’s part number is matching.