Skip to main content

Notifications

Community site session details

Community site session details

Session Id : VMwOBXPgh3f+v44Om9lgox
Power Automate - General Discussion
Unanswered

Using Power Automate to send an email when a duplicate excel entry is found

Like (0) ShareShare
ReportReport
Posted on 9 Nov 2021 21:58:19 by 2

Hello Community.  I am using Forms to gather data, then using Excel to confirm data accuracy.  When the Form is submitted, it asks users for email address, name, and a unique alpha numerical ID.  Sometimes, the sender will use the same ID, causing a duplicate entry in Excel.  Is there a way for Power Automate to catch the duplicate entry, and send the submitter an email advising of this duplicate entry?  I am running into issues where Power Automate wont allow me to identify duplicate results, but I may be missing something.  Thank you in advance for any assistance!

  • mahoneypat Profile Picture
    1,720 on 10 Nov 2021 at 00:31:18
    Re: Using Power Automate to send an email when a duplicate excel entry is found

    In that case, one way to check for duplicates would be to Select the ID column out of the array and then have a condition where the count of rows of that array is greater than the distinct count of IDs in that array.  To get that you can union( ) the array to itself and then count. 

     

    Pat

  • KAPA Profile Picture
    2 on 09 Nov 2021 at 23:20:33
    Re: Using Power Automate to send an email when a duplicate excel entry is found

    @mahoneypat we use the excel sheet as a real time data entry system, so when the form is submitted, we can see the results in the excel sheet instantly and make any corrections if needed.  I am just trying to automate the notification part of our process, so that if excel sees a duplicate ID as the forms are submitted, it will send an email to the submitter.  

  • mahoneypat Profile Picture
    1,720 on 09 Nov 2021 at 22:22:45
    Re: Using Power Automate to send an email when a duplicate excel entry is found

    You would need to add a step to List Rows in Excel table with the values collected so far, and then create a Condition that checks if the Filtered array (when ID equals the newly submitted ID) has any rows.  If not, the new row is added to the Excel table.

     

    You could just deal with the duplicates with Power BI (or Power Query in Excel) on the backend too, but I don't know your scenario.

     

    Pat

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

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - General Discussion

#1
stampcoin Profile Picture

stampcoin 23

#2
Pstork1 Profile Picture

Pstork1 20 Most Valuable Professional

#3
Gprior Profile Picture

Gprior 19

Overall leaderboard
Loading started