Duplicates in Sharepoint

Question

How do conditionally format duplicates in a SharePoint list?

Answer 1

Hi @Elinor Poole
Thank you for posting your question in the Microsoft Q&A forum. 
To conditionally format duplicates in a SharePoint list, you can use a combination of column formatting with JSON, Power Automate flows.  
After testing, here are steps you may follow: 

1.Using Power Automate to flag duplicates: 
Go to Microsoft Power Automate | Home > Create > Automated cloud flow > Name your flow > Choose the trigger When an item is created or modified. 
Use the following flows as a reference and customize them as needed for your situation. 

2.Using JSON Column formatting 
You can apply JSON formatting to a column to visually highlight duplicates. 

{ 
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json", 
"elmType": "div", 
"style": { 
"background-color": "=if([$Duplicate] == true, '#fff4ce', '')", 
"color": "=if([$Duplicate] == true, '#a80000', '')", 
"font-weight": "=if([$Duplicate] == true, 'bold', '')", 
"padding": "4px" 
}, 
"children": [ 
{ 
"elmType": "span", 
"txtContent": "=@currentField" 
} 
] 
}

This is the result:
I hope this helps.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".   

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.