PowerApps restrict duplicate data entry based on data field value

(0) Share

Report

Posted on by leonardbd

118

Hi There,

I'm looking for a short form of coding which will check duplicate data in difference fields and restrict data duplication before submitting for save.

Such as in following image, in each FO and Team field there cannot be two Category="Approver" which will restrict the duplication and notify a message before saving the data. My Approvers data table if following ..

Such as: If I try to add a record, Name: Any Name, Category: Approver, Team: Finance, FO: CXB, it will restrict the data entry if it finds the name with same Category, Same Team and same FO.

That mean in each FO and each Team there will be one Approver but there can be same Name as Approver in Difference Team in different FO. such as

Now I have applied a formula but it seems it will be too much coding for this simple requirement.

*If(
 !IsBlank(LookUp('ExitCL02-Approvers', DorpdownCategory.Selected.Value = "Approver" && Category.Value = "Approver" && Team.Value="ICT" && FO.Value="CXB" )),
 Notify("There is already an Approver exist in " & DataCardValue12.Selected.Value & " Field Office")),
 SubmitForm(Form1);ResetForm(Form1)
);
And so on and so on....

Not sure how to achieve that. Appreciate your help on this

Regards

Leo

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,434 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @leonardbd ,

It is better to make the drop-down trigger first as below, but (to answer your other question) all the code is necessary to achieve the result you need

If( DorpdownCategory.Selected.Value = "Approver" && !IsBlank( LookUp( 'ExitCL02-Approvers', Category.Value = "Approver" && Team.Value="ICT" && FO.Value="CXB" ) ), Notify( "There is already an Approver exist in " & DataCardValue12.Selected.Value & " Field Office" ), SubmitForm(Form1); ResetForm(Form1) );

Assuming also that you have the current Team and FO in a control or Variable somewhere, you would not need to hard-code this as you have.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Visit my blog Practical Power Apps

Was this reply helpful? Yes No
leonardbd 118 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Warren,
This works just fine. Now Im trying to figure out defining the variable to avoid hard coding.
Thanks buddy
Regards
Leo

Was this reply helpful? Yes No
leonardbd 118 on at

Like
a
(0)

Report
Copy link

Link copied!
I just figured it out. Here it goes like this. I have defined two local variables in both of the dropdown's (Team and FO) OnSelect event such as
UpdateContext({LocVarTeam:DataCardTeam.Selected.Value})
and
UpdateContext({LocVarFO:DataCardFO.Selected.Value})
Then I have applied the variable in your given code and saved from lots of hard coding
If( DataCardCategory.Selected.Value = "Approver" && !IsBlank( LookUp( 'ExitCL02-Approvers', Category.Value = "Approver" && Team.Value=LocVarTeam && FO.Value=LocVarFO ) ), Notify( "There is already an Approver exist in " & DataCardLocation.Selected.Value & " Location" ), SubmitForm(FormListUpdate); ResetForm(FormListUpdate) )
Thanks a lot for your guidance 🙂

Was this reply helpful? Yes No