Loop through list items and update field value

⌘K

Loop through list items and update field value

This activity allows looping through list items and updates items field value.

SharePoint Workflow Designer Phrase
loop_through_list_items_and_update_field_value_1
Parameters

Input parameters

ParameterDescriptionExample
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 impersona teIgnore 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 underUser name (optional)
User password (optional)User password who you want the workflow must be run underUser password (optional)
List identifierList 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 QueryCAML 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 NameDisplay field nameStatus
Field valueNew field valueNEW_VALUE

Example

loop_through_list_items_and_update_field_value_2

How can we help?