How to find duplicate values in Repeating Gallery

(0) Share

Report

Posted on by knsrinath

527

I have a repeating table gallery & need to find and display duplicate values in Textinput out side gallery.

I have used following formula

TextInput15 Default = If(RepeattingTable_5.Selected.ComboBox2_6=ComboBox2_6,"Duplicate","No Duplicate")

Request you help me to resolve.

Thanks & Regards

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

Sort by

mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

So I belive that you are getting an evaluation of true due to the fact that you are saying the following:
If(ComboBox = ComboBox,"Duplicate","No Duplicate") which will always evaluate to true and therefor "Duplicate". What you want to do is compare the values in the label there I am assuming. I.E. If(A+4 = A, "Duplicate","No Duplicate").

Was this reply helpful? Yes No
knsrinath 527 on at

Like
a
(0)

Report
Copy link

Link copied!

@mmollet

Yes,
I am comparing repeating gallery inside Combobox, But result is required in TextInput Out side gallery.

Thanks & Regards

Was this reply helpful? Yes No
mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok so how are you choosing what to search through? Or do you just want to know if there are any duplicates in the entire list/gallery? Also do you care what the duplicates are or just that there are duplicates?

Was this reply helpful? Yes No
mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

Here are some examples of ways this could be done:
Button At top: ClearCollect(test, ["mike","john","jake","ron","sam","blake","mike","adam","ron"])
OG List: test
Distinct List: Distinct(test,Value)
Duplicates List: Filter(GroupBy(test,"Value","Duplicate"),CountRows(Duplicate)>1)

Was this reply helpful? Yes No
knsrinath 527 on at

Like
a
(0)

Report
Copy link

Link copied!

@mmollet

Required in one combobox (Combobox2_6) only, to just warning to user do not enter duplicate value again in repeating gallery.

Thanks & Regards

Was this reply helpful? Yes No
mmollet 3,187 on at

Like
a
(0)

Report
Copy link

Link copied!

So I would try to use my code from duplicates example. If the user enters a value that is in that list then you can be sure that what they entered is already in the list and will therefor create a duplicate. This is my test for this:

Code for label: If(TextInput3.Text in Gallery2_2.AllItems.Value, "Duplicate", "Not Duplicate")

Was this reply helpful? Yes No
knsrinath 527 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @mmollet

User enter first row and if user enter same value in same Combobox of second row, required display warning information automatically inside the gallery or out side galley to prevent duplicate entries.

Thanks & Regards

Was this reply helpful? Yes No
Verified answer

knsrinath 527 on at

Like
a
(0)

Report
Copy link

Link copied!
Hi All
The below formula is working fine

Label1 Text Property = If(CountRows(Distinct(RepeattingTable_5.AllItems, ComboBox2_6)) < CountRows(RepeattingTable_5.AllItems), "Duplicate", "No duplicate")

Thanks & Regards

Was this reply helpful? Yes No