Skip to main content

Notifications

Community site session details

Community site session details

Session Id : hoBVeNYxPG33ubMiKgl7BQ
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

Understanding Microsoft Agents - Introductory Session

Confused about how agents work across the Microsoft ecosystem? Register today!

Warren Belz – Community Spotlight

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

Congratulations to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 146,745 Most Valuable Professional

#2
RandyHayes Profile Picture

RandyHayes 76,287 Super User 2024 Season 1

#3
Pstork1 Profile Picture

Pstork1 66,091 Most Valuable Professional

Leaderboard
Loading started