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

I have the same question (0)

All responses (3)

Answers (0)

StretchFredrik 3,395 Super User 2025 Season 2 on at

Like (1)

Report
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 😃

Was this reply helpful? Yes No
jed76 on at

Like (0)

Report

Many thanks.

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

Was this reply helpful? Yes No
jed76 on at

Like (0)

Report

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?

Was this reply helpful? Yes No