web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / How to detect and temp...
Power Apps
Unanswered

How to detect and template fill duplicated items from a gallery

(0) ShareShare
ReportReport
Posted on by 114

Hello all,

One of my gallery in my app has many duplicated records and I like to know how can I filter/search these duplicates and when found, mark them using template fill property.  

Duplicate record is defined if record/s has the same identical entry for the below columns, except for score column which is not blank.

Data source: SP List, Name: 'Triaged Review List'

ProgramID-- type number

QuestionNumber-- type number

Member-- type single line of text and using User().FullName

Score-- type choice.  

If you look at the image below, row # 3,4, and 5 are considered duplicated records.

davidvo68_0-1656345887298.png

Here is the code that I have so far for my detect duplicates button onselect property.

I am looking for help to modify the code in order to detect and template fill the duplicated records. 

Again, the code below is not complete and I need help to modify it.

If(CountIf(AddColumns(GroupBy('Triaged Review List',"ProgramID" ,"DupGroup"), "DupCount", CountRows(DupGroup)), DupCount>1)>0,
Notify("Duplicates Found") );

Thank you.

Categories:
I have the same question (0)
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @davidvo68 

    For the Template fill property

    With(
     {
     tbl: GroupBy(
     AddColumns(
     'Triaged Review List',
     "chk",Concatenate(
     ProgramID,
     QuestionNumber',
     Member)
     )
     ), "chk","otherstuff"
     )
     },
     If(
     CountRows(tbl.otherstuff) > 1,
     Red,
     Transparent
     )
    )

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
Haque Profile Picture

Haque 94

#2
WarrenBelz Profile Picture

WarrenBelz 82 Most Valuable Professional

#3
Kalathiya Profile Picture

Kalathiya 38 Super User 2026 Season 1

Last 30 days Overall leaderboard