Loop through list items and update field value
This activity allows looping through list items and updates items field value.
SharePoint Workflow Designer Phrase
Parameters
Input parameters
| Parameter | Description | Example |
|---|---|---|
| Site URLs (optional) | The URLs of a SharePoint sites (semicolon delimited) where you want to update field value. If thevalue field is empty, current site will be used. | https://contoso/SiteUrl; https://contoso/Sites/SiteUrl;[%Workflow Context:Current Site URL%]subSite |
| Folder Path(optional) | The web site relative URL of a list folder from which results will bereturned | /Folder/Folder/Subfolder |
| Is impersonate | Ignore permissions of the user which initiated workflow. Execute activity under the Application Pool identity. | Yes/No |
| User name (optional) | User login name who you want the workflow must be run under | User name (optional) |
| User password (optional) | User password who you want the workflow must be run under | User password (optional) |
| 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 isempty, 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> | ||
| Field Name | Display field name | Status |
| Field value | New field value | NEW_VALUE |
Example
