Duplicate Documents

[Wilson]

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.

Attachments:

1. 

   folder_closed.png
   

2. 

   folder_open.png
   

3. 

   folder_caml.png
   

[Alexander Bautz]

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

[Author]

Posts