web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Power Apps - Building Power Apps
Unanswered

Duplicate Check (Form to Data Source) - Thoughts/Ideas

(0) ShareShare
ReportReport
Posted on by 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

Categories:
I have the same question (0)
  • cha_cha Profile Picture
    4,932 Moderator on at
    Re: Duplicate Check (Form to Data Source) - Thoughts/Ideas

    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.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Chiara Carbone – Community Spotlight

We are honored to recognize Chiara Carbone as our Community Spotlight for November…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 766 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 419 Super User 2025 Season 2

#3
developerAJ Profile Picture

developerAJ 235

Last 30 days Overall leaderboard