Unanswered

Identify duplicate values of different cards in a form

(0) Share

Report

Posted on by MarkFay

Hi Everyone,

I am trying to identify when two datacards with text fields within a form have duplicate values before submitting. My thought was to create a variable based on an If statement then if true show a warning and if false submit form. Question is how do I identify if the text fields in the different cards match. I tried this

Set (_Dup, If(DataCardValue213.Text)=(DataCardValue215.Text),false))

Powerapps did not complain about the command but it does not identify a duplicate.

Anyone have an idea how to accomplish this??

Thanks

Mark

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report
@MarkFay

You don't need any variable for this.

If you are just trying to show a notification banner, then your formula would be the following:

If(DataCardValue213.Text = DataCardValue215.Text, Notify("Duplicate Error"), SubmitForm(yourForm) )

I hope this is helpful for you.

Was this reply helpful? Yes No
MarkFay 44 on at

Like (0)

Report

Thanks Randy,
a good option that I will play with, but right now I cant seem to get the app to identify when a duplication exists. This part doesn't seem to work.
DataCardValue213.Text=DataCardValue215.Text
How do I get the app to look at these fields and determine if they are the same?

M

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (0)

Report

@MarkFay

What about it is not working?

Was this reply helpful? Yes No
MarkFay 44 on at

Like (0)

Report

As a test I may trying to see if a duplicate entry will set a variable. I have a text label that will display if variable is true. I have a button that on Select is Set (_Dup, If(DataCardValue213.Text)=(DataCardValue215.Text),false))
So in my form I have two fields that I enter the same information

When I click on the button, it does not set the variable so I assume the condition of DataCard213 and 215 is not seen as equal for some reason. Could it be because it is a text field?

Was this reply helpful? Yes No
RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report
@MarkFay

Your formula is not correct. Please use the formula that I provided for you.

If(DataCardValue213.Text = DataCardValue215.Text, Notify("Duplicate Error"), SubmitForm(yourForm) )

Was this reply helpful? Yes No
MarkFay 44 on at

Like (0)

Report

Ok thanks that seemed to work. Now for the $1M bonus question, as you could see in the image I uploaded, I have several fields that I want to compare for duplication. Do I have to create an OR for each possible combination or is there an easy way to comapre all?

Was this reply helpful? Yes No
Verified answer

RandyHayes 76,297 Super User 2024 Season 1 on at

Like (1)

Report
@MarkFay

No problem...you can incorporate them all in as you need.

If(DataCardValue213.Text = DataCardValue215.Text || DataCardValue213.Text = DataCardValueX.Text || ..etc.., Notify("Duplicate Error"), SubmitForm(yourForm) )

Was this reply helpful? Yes No
MarkFay 44 on at

Like (0)

Report

Sorry one more question. After playing with this I am getting a false positive when the fields are blank. I tried to
If( !IsBlank (DataCardValue213) &&
!IsBlank(DataCardValue215) &&
!IsBlank(DataCardValue214) &&
DataCardValue213.Text=DataCardValue215.Text ||
DataCardValue213.Text=DataCardValue214.Text, Notify(Error),Submit(Form))
But that doesnt work it still sees a duplicate if Datacard 214 is the only card with text.
Is my !IsBlank logic wrong?

Was this reply helpful? Yes No