You’re offline. This is a read only version of the page.
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.
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.
For the Template fill property
Share
Report
All responses (
Answers (
With(
{
tbl: GroupBy(
AddColumns(
'Triaged Review List',
"chk",Concatenate(
ProgramID,
QuestionNumber',
Member)
)
), "chk","otherstuff"
)
},
If(
CountRows(tbl.otherstuff) > 1,
Red,
Transparent
)
)
