Skip to main content

Notifications

Power Automate - General Discussion
Answered

find duplicate and update status value to Duplicate item

(1) ShareShare
ReportReport
Posted on by 103

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.

 

  1. When the item is created
  2. Search Testid duplicate
  3. if a duplicate testid is found then update the most current date time item Status value to "Duplicate item"
  4. Send an email to Manager- duplicate item found in the list take appropriate action. 

Dhaval2002p_0-1679430157394.png

 

 

  • abm abm Profile Picture
    abm abm 32,291 on at
    Re: find duplicate and update status value to Duplicate item

    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

  • Mim10 Profile Picture
    Mim10 4 on at
    Re: find duplicate and update status value to Duplicate item

    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

  • Dhaval2002p Profile Picture
    Dhaval2002p 103 on at
    Re: find duplicate and update status value to Duplicate item

    @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! 🙏

     

    1. When the item is created
    2. Search Testid duplicate
    3. if a duplicate testid is found then update the most current date time item Status value to "Duplicate item"
    4. Send an email to Manager- duplicate item found in the list take appropriate action. 
  • Verified answer
    abm abm Profile Picture
    abm abm 32,291 on at
    Re: find duplicate and update status value to Duplicate item

    Hi @Dhaval2002p 

     

    Please have a look at this tutorial video based on this.

     

    https://youtu.be/k30iiYlokRc

     

    Thanks

  • abm abm Profile Picture
    abm abm 32,291 on at
    Re: find duplicate and update status value to Duplicate item

    Hi @Dhaval2002p 

     

    Check your email? I could offer a quick screenshare. There are couple of things to change here.

     

    Thanks

  • Dhaval2002p Profile Picture
    Dhaval2002p 103 on at
    Re: find duplicate and update status value to Duplicate item

    @abm I would appreciate it if you guide me step by step on what should I write in the Top count and next....

  • abm abm Profile Picture
    abm abm 32,291 on at
    Re: find duplicate and update status value to Duplicate item

    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

  • Dhaval2002p Profile Picture
    Dhaval2002p 103 on at
    Re: find duplicate and update status value to Duplicate item

    Hi, @abm Screenshot for the workflow.Full abm.jpg

  • abm abm Profile Picture
    abm abm 32,291 on at
    Re: find duplicate and update status value to Duplicate item

    Hi @Dhaval2002p 

     

    Could you post a screenshot of your flow please?

     

    Thanks

  • Dhaval2002p Profile Picture
    Dhaval2002p 103 on at
    Re: find duplicate and update status value to Duplicate item

    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. 

     

    Dhaval2002p_0-1680020199105.png

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,508

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,839

Leaderboard