You’re offline. This is a read only version of the page.
240
Hello,
I am hoping for ideas, on how best to check for duplicates of a submitted form and what is possible to set up to avoid and stop this from happening.
Basically i want something that doesn't allow a form to be submitted if an identical/partial match of an already existing record is already present within the data source (which happens to be an excel spreadsheet).
I had the idea of maybe a check to see if some information is already present so a unique identifier like an employee number paired with a date field being recognised as already exisiting on the data source. Creating the duplicate flag.
Open to any idea/experience that anyone has with this though and the best way to prevent duplicates.
Thank you!
Chris
Hello @Appy1
I would suggest you use Power Automate.
When a form is submitted it goes to an automated flow. In that automated flow, you use the form inputs like maybe Email to check if a record with email exists in a database.
After that, if there is a result, you can create an action on maybe to tell that person that a prior submission has been made and not add it to your data store.
Share
Report
All responses (
Answers (
