Nintex Newbie

Quering empty subfolders with Office 365 query list action

I'm trying to use the office 365 query list item to see if a subfolder is empty or not.

When I make a query trough the query builder it looks like the query only see's documents and not folders. See my query below:


When I open the CAML editor and change the view scope from Recursive to RecusiveAll it seems that folders are included. Although my search contains a variable and this doesn't seems to work in the CAML editor.

<View Scope="RecursiveAll">
            <FieldRef Name="ItemChildCount" />
            <FieldRef Name="Name" />
                    <FieldRef Name="Name" />
                    <Value Type="Text">Post Approval Attachments</Value>
                    <FieldRef Name="Name" />
                    <Value Type="Text">[%Value:Use text builder%]</Value>
    <RowLimit> 10</RowLimit>

I've tried to change the <Value Type="Text">[%Value:Use text builder%]</Value> to <Value Type="Text">{Variable:CurrentACPwithoutXML}</Value>.

Any ideas how to include folder items in the query builder or how to use a variable in the CAML editor?

Thanks in advance,


0 Kudos