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") );
For the Template fill property
'Triaged Review List',
CountRows(tbl.otherstuff) > 1,
Keep up to date with current events and community announcements in the Power Apps community.
Check out the latest Community Blog from the community!