Duplicate Documents

Forums vLooup for SharePoint Duplicate Documents

This topic contains 1 reply, has 2 voices, and was last updated by  Alexander Bautz 4 months ago.

  • Author
    Posts
  • #24317

    Wilson
    Participant

    Hi Alex,
    I’m seeing duplicate documents displayed in vlookup when they are nested in a folder with same lookup attribute (library field I filter on). Is there a way to only show documents within their respective folder structure. The library only has a total of 3 docs in it, but when vlookup shows 5.I should only see the 3 files within the folder structure.

    FYI, I am populating filtering attribute (The ID I filter with CAML in vlookup config) on document library outside of DFFS via MS FLOW.

  • #24338

    Alexander Bautz
    Keymaster

    Hi,
    By default this solution will list all items – both files and folders that matches with the query, but you can change your CAML like this to have it only list folders initially:

    <Where>
    <And>
    <Eq><FieldRef Name='FSObjType' /><Value Type='Integer'>1</Value></Eq>
    <Eq><FieldRef Name='SPCustomerAccountID' /><Value Type='Text'>[currentItem:ID]</Value></Eq>
    </And>
    </Where>

    Let me know how this works out.

    Alexander

You must be logged in to reply to this topic.