Office 365 Workflows for SharePoint Designer 2013

Get list items (CAML)

This activity allows getting list items using CAML Query from any site.

SharePoint Designer phrase


Output parameters

Parameter Description Example
Items The dictionary that represents the items Variable:Items
Item Count The number of items in the dictionary Variable:Count

Input parameters

Parameter Description Example
List identifier List for querying. The value could be list name, list base template, guid (not supported with multiple sites) or list URL (The web site relative URL). ). If the value field is empty, current list will be used. Documents [%Workflow Context: List ID %] 107 /Lists/Tasks
Caml Query CAML query that will be run <View Scope='RecursiveAll'> <Query> <Where> <Contains> <FieldRef Name='FileLeafRef' /> <Value Type='File'> .docx </Value> </Contains> </Where> <OrderBy> <FieldRef Name='ID' /> </OrderBy> </Query> <ViewFields> <FieldRef Name='FileLeafRef' /> <FieldRef Name='FileRef' /> </ViewFields> <RowLimit>10</RowLimit> </View>
Folder Path The web site relative URL of a list folder from which results will be returned /Lists/ListName/Folder1/SubFolder
Site URLs The URLs of a SharePoint sites (semicolon delimited). If the value field is empty, current site will be used. https://contoso/SiteUrl; https://contoso/Sites/SiteUrl; [%Workflow Context:Current Site URL%]subSite