Remove Duplicates From Collection In SharePoint 2013 And Office 365 Using Nintex Workflows

Welcome to an article on how to remove duplicates from Collection in SharePoint 2013 and Office 365 using Nintex Workflows. This article will display the action “Remove Duplicates from Collection” so that all my developer friends don’t have to spend much time and effort while using this function in their projects.

This is a wonderful action as it will delete all duplicates by itself and generate a single output file with no duplicates.

Let’s see the implementation of this functionality.

  • Create a list, Dev Testing.

  • Click on the List tab on the Top ribbon and click on Nintex Workflows.

    Nintex Workflows

  • You will see the following screen, to create a new workflow.

  • Click on “Create new workflow”.

    Create new workflow

  • You will come to the design phase of the Nintex workflows.

  • Add the action, “Remove Duplicates from Collection” either by right click on the workflow or by dragging and dropping from the left toolbox.

    Remove Duplicates from Collection

  • Now let’s configure it.

  • When you double click on the action the following screen opens up.

    double click on the action

    Configure:

    • Target Collection: Choose the variable of a collection from where you want to delete the duplicates.
    • Output: Select a collection variable to store the output with no duplicates.

  • Now we have configured our workflow, let’s go and publish it to use.

  • Click on Publish on the left corner of the ribbon of Nintex Designer.

    Click on Publish

  • You can see the following screen,.

    Publish

  • Give your workflow a name.

  • Description.

  • Choose your task list where it should store the tasks, It will be Workflow Tasks by default.

  • Choose your history list where it should store the history logs, It will be Workflow History by default.

  • Start Options:

      - You can either start your workflow manually.
      - Or you can start your workflow automatically when an item is created
      - Or you can start your workflow automatically when an item is modified.

  • Click on Publish.

  • Your workflow will get published.

So in this article we saw how to remove duplicates from Collection in SharePoint 2013 and Office 365 using Nintex Workflows. This action is necessary to clean duplicates from a collection which will generate a new file without duplicates.

We will see more new articles on the actions of Nintex Workflows in the other parts of the article. Till then, keep learning!