Forum Discussion
How to create an alert when a duplicate detail in item of SharePoint list is created
Dear Community,
I have created a list when multiple items are created however in a few items the details in one particular column are the same.
I need to create a condition so that if a new item is created with the same details, it should pop up that the entry already exists, however it should not prevent by doing the entry.
5 Replies
- I know this is old, but you can go into the SharePoint List settings, click on the column title, and select "enforce unique values." When entering info via SharePoint List directly, it will tell you "Error: This value already exists in the list."
You can accomplish this with a flow or an Azure function, but you have to customise the pop up
this example is for item modification on a column
You have a trigger when an item is created or modified
https://powerautomate.microsoft.com/it-it/blog/run-a-flow-when-a-sharepoint-column-is-modified/- Thanks for the response.
Can you help me if we can use conditional formatting in one column and get the duplicate value highlighted with some color as we do in excel?- Try here, lots of examples
https://github.com/SharePoint/sp-dev-docs/blob/master/docs/declarative-customization/column-formatting.md
suneel1987 no that is not possible.
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)
