Power Platform Community Forum Thread Details

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.

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:

Building Power Apps