Get list items (CAML)
This activity allows getting list items using CAML Query from any site.
SharePoint Designer phrase
Parameters
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 beused. | 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 sitewill be used. | https://contoso/SiteUrl; https://contoso/Sites/SiteUrl;[%Workflow Context:Current Site URL%]subSite |
Example
