Set SharePoint Column

 

The Set SharePoint Column plug-in allows you to set field values in a SharePoint list based on the current value of a form field.

This plug-in allows you to update only one SharePoint column value. If you want to update more than one column, use multiple Set SharePoint Column plug-ins in your workflow or use the Update SharePoint List plug-in.

Value Pair	Description
column	The name of the column whose value you want to update.
list	The name of the SharePoint list to which you want to export the data.
query	The query parameters to search for a record listing in the SharePoint list.
site	The SharePoint site that contains the list to which you want to export the data.
value	The name of the SharePoint field whose value you want to use to update the column.

Example

• column – Dept
• list – Employee Location
• query – [Employee Name] == @[name]
• site – http://acme.com/sv/FormEx
• value – [deptTo]

This example queries the list Employee Location on the site http://acme.com/sv/FormEx for rows where the Employee Name column matches the name field in the current list. If any rows are returned, it sets the Dept column to the value in the deptTo SharePoint field.