Unanswered

Flag duplicate item in a gallery

(0) Share

Report

Posted on by jed76

I have a gallery where I can add multiple blank rows using the DEFAULTS function.

I am trying to check for duplicate rows based on certain criteria but I only seem to be able to get an accurate result once the gallery is patched back to the data source? How can I check for duplicate rows in the gallery as the items are added. Here is my current formal:

CountRows(

Filter(MYGALLERY,

TaskType=4,

CrewName.DisplayName=ComboBox2_1.Selected.DisplayName))

As I understand it, this is only checking against rows which have been patched back to the original data source (in this case, CrewName.DisplayName). How can I flag and count the duplicate rows in realtime as each new line in the gallery is added?

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

Fredrik_A 3,644 Super User 2026 Season 2 on at

Like
a
(1)

Report
Copy link

Link copied!
Hello,

Try this:

ForAll( Distinct( YourDataSource, TheNameColumn ), LookUp( YourDataSource, TheNameColumn= Result ) )

If this solved your issue please mark the post as Solved.
Also, if you appreciated my answer, don't forget to give it a Thumbs Up 😃
jed76 on at

Like
a
(0)

Report
Copy link

Link copied!

Many thanks.

I have tried this and I am getting "expected text value"?
jed76 on at

Like
a
(0)

Report
Copy link

Link copied!

I think that it because I am putting the formula into the TEXT property of a label. Where should I place it please and how can I use it notify the flag?