Download and setup a free tool named Kutools for Excel from here , the page contains also description how to use it to mark the duplicated column.Export AllItems to Excel using the Excel action in the ribbon, and make sure the ID Column is part of the export.If you are using SharePoint Online, you can use Sharegate, however this step is not mandatory. I took back-up from the List, if you use SharePoint On-premise version, you can take back-up of the site.To solve the situation I did the following, This solution can be applied on all SharePoint versions 2010, 2013, 2016, & SharePoint Online, as the script is written to work as Client Object Model. He wants to solve the situation in a safe way with no risk, by removing duplicate items and keep the Original one. He was running a certain PowerShell script to update a SharePoint Online list with Data, it reaches 7000 items, a certain issue occurred in the script, and he found that he as 20,000 items in the same list, 70% was duplicates. We have faced recently a critical situation with a customer: Posted on 24 June، 2018 Updated on 25 June، 2018 How to Remove Duplicates items in SharePoint Online List and keep one by PowerShell ?
0 Comments
Leave a Reply. |