Help Center>Foundation Help

Applies to:

  • Winshuttle Foundation

Set SharePoint Column plugin properties

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

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

NOTE: For site and list parameters, enter the site first, and then the list will be populated in the dropdown.

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.