I appreciate it if you can help me to build a workflow for this SharePoint list. I tried multiple methods but for some reason, it's updating the status for all new items even though it's not duplicate.
Hi @Mim10
Just before the deletion you can find what are the duplicates, store the Id of both. Once you have the Id you can update the record.
Thanks
Hi, I found the video tutorial very helpful and have managed to identify duplicates. I don't delete them immediately as some duplicates are ok so we leave them for review. Once the review is completed and we determine we need to remove an item, the column still shows as there being a duplicate. Even though the duplicate has been removed. How do I get the column to update when an item is deleted? Many thanks, Mim
@abm Thank you for making the video, I made the workflow based on the steps, and the workflow ran successfully. It met all these following requirements. Thank you So much for your Great Help! 🙏
Hi @Dhaval2002p
Check your email? I could offer a quick screenshare. There are couple of things to change here.
Thanks
@abm I would appreciate it if you guide me step by step on what should I write in the Top count and next....
Hi @Dhaval2002p
So you can't use the TOP count to one here. You need to get all the duplicates then order the result after. Once it ordered then use the highest Id for the update.
Thanks
Workflow ran successfully and now it's not updating the status for non-duplicate items which is good.
The second issue still persists I do not want to change the status for the old duplicate item# as shown in the image below.