Query Subfolder › Forums › vLooup for SharePoint › Query Subfolder This topic contains 2 replies, has 2 voices, and was last updated by Alexander Bautz 2 months ago. Author Posts October 7, 2017 at 10:21 #18376 MichaelParticipant Hi, i’m not sure what exactly i’m doing wrong. I just want to Show items from a specific Folder, so i use the following query: <Query><Where><IsNotNull><FieldRef Name=’ID’ /></IsNotNull></Where></Query><QueryOptions><Folder>myLib/CustomFolder</Folder></QueryOptions> When i use this query e.g. in the query builder tool, i only recieve the Contents of this Folder. When i add it to the vlookup query configuration, all items / Folders in the library are shown. Can you please give me a hint what i’m doing wrong?! Regards, Michael October 9, 2017 at 20:15 #18400 Alexander BautzKeymaster Hi, Based on the CAML syntax you are not doing anything wrong, but unfortunately I haven’t added support for specifying the QueryOptions like this in the vLookup setup. I’ll see what I can do about it in the next release. Alexander October 9, 2017 at 20:32 #18402 Alexander BautzKeymaster I did another test and found that you can use this in the “Write your own CAML-query” field: <Where><Eq><FieldRef Name='FileRef' /><Value Type='Text'>SITE_URL/DOC_LIB/SUBFOLDER</Value></Eq></Where> Alexander Author Posts You must be logged in to reply to this topic.