Duplicate Documents

Forums vLooup for SharePoint Duplicate Documents

Viewing 1 reply thread
  • Author
    • #24317

      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

      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:

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

      Let me know how this works out.


Viewing 1 reply thread
  • You must be logged in to reply to this topic.