How to create an alert when a duplicate detail in item of SharePoint list is created

%3CLINGO-SUB%20id%3D%22lingo-sub-3030514%22%20slang%3D%22en-US%22%3EHow%20to%20create%20an%20alert%20when%20a%20duplicate%20detail%20in%20item%20of%20SharePoint%20list%20is%20created%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3030514%22%20slang%3D%22en-US%22%3E%3CP%3EDear%20Community%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20created%20a%20list%20when%20multiple%20items%20are%20created%20however%20in%20a%20few%20items%20the%20details%20in%20one%20particular%20column%20are%20the%20same.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20need%20to%20create%20a%20condition%20so%20that%20if%20a%20new%20item%20is%20created%20with%20the%20same%20details%2C%20it%20should%20pop%20up%20that%20the%20entry%20already%20exists%2C%20however%20it%20should%20not%20prevent%20by%20doing%20the%20entry.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3030514%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EMicrosoft%20Lists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3030828%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20create%20an%20alert%20when%20a%20duplicate%20detail%20in%20item%20of%20SharePoint%20list%20is%20created%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3030828%22%20slang%3D%22en-US%22%3ETry%20here%2C%20lots%20of%20examples%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-docs%2Fblob%2Fmaster%2Fdocs%2Fdeclarative-customization%2Fcolumn-formatting.md%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fgithub.com%2FSharePoint%2Fsp-dev-docs%2Fblob%2Fmaster%2Fdocs%2Fdeclarative-customization%2Fcolumn-formatting.md%3C%2FA%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3030804%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20create%20an%20alert%20when%20a%20duplicate%20detail%20in%20item%20of%20SharePoint%20list%20is%20created%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3030804%22%20slang%3D%22en-US%22%3EThanks%20for%20the%20response.%3CBR%20%2F%3E%3CBR%20%2F%3ECan%20you%20help%20me%20if%20we%20can%20use%20conditional%20formatting%20in%20one%20column%20and%20get%20the%20duplicate%20value%20highlighted%20with%20some%20color%20as%20we%20do%20in%20excel%3F%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3030633%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20create%20an%20alert%20when%20a%20duplicate%20detail%20in%20item%20of%20SharePoint%20list%20is%20created%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3030633%22%20slang%3D%22en-US%22%3E%3CP%3EYou%20can%20accomplish%20this%20with%20a%20flow%20or%20an%20Azure%20function%2C%20but%20you%20have%20to%20customise%20the%20pop%20up%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ethis%20example%20is%20for%20item%20modification%20on%20a%20column%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20have%20a%20trigger%20when%20an%20item%20is%20created%20or%20modified%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fpowerautomate.microsoft.com%2Fit-it%2Fblog%2Frun-a-flow-when-a-sharepoint-column-is-modified%2F%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%22%3Ehttps%3A%2F%2Fpowerautomate.microsoft.com%2Fit-it%2Fblog%2Frun-a-flow-when-a-sharepoint-column-is-modified%2F%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3030554%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20create%20an%20alert%20when%20a%20duplicate%20detail%20in%20item%20of%20SharePoint%20list%20is%20created%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3030554%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1239372%22%20target%3D%22_blank%22%3E%40suneel1987%3C%2FA%3E%26nbsp%3Bno%20that%20is%20not%20possible.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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.

4 Replies

@suneel1987 no that is not possible.

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

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?