cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Doors1980
Level: Powered On

Prevent Duplicate data based on two fields

Hi,

 

I've got a simple app gathering data using the following fields in the screenshot.  I need validation to fail on the new entry if a previously submitted item contains duplicate data for only the "Mother and baby" and "Issue" fields.

 

How would I go about achieving this?

 

Thanks.

 

screenie.png

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: Prevent Duplicate data based on two fields

Hi @Doors1980,

 

It is recommended to restrict the data as Unique from the data source side.

If you would perfer to add data validation through PowerApps, check the following best practises first:

A few best practices in Data Validation

 

Basically, you should add a check formula with the Disabled property of the submit button, once the entered string matches the needs, then make the button enable, also providing a reminding notes would be better.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Community Support Team
Community Support Team

Re: Prevent Duplicate data based on two fields

Hi @Doors1980,

 

It is recommended to restrict the data as Unique from the data source side.

If you would perfer to add data validation through PowerApps, check the following best practises first:

A few best practices in Data Validation

 

Basically, you should add a check formula with the Disabled property of the submit button, once the entered string matches the needs, then make the button enable, also providing a reminding notes would be better.

 

Regards,

Michael

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

Doors1980
Level: Powered On

Re: Prevent Duplicate data based on two fields

Thanks @v-micsh-msft , I get the principal but need a head start on the formula.

 

Thanks. Smiley Very Happy

Helpful resources

Announcements
thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

SecondImage

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Kudoed Authors (Last 30 Days)
Users online (4,340)