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!
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
@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.
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
WarrenBelz
146,745
Most Valuable Professional
RandyHayes
76,287
Super User 2024 Season 1
Pstork1
66,091
Most Valuable Professional