Help Center>Foundation Help

Applies to:

  • Winshuttle Foundation

Update SharePoint List plugin properties

«Back to Plugins Table

Related Topics

The Update SharePoint List plugin allows you to insert, update, and delete items in a SharePoint list.

This plugin looks at the source and destination lists, and will include only those columns that match up exactly between the two lists.

For example, if the source list has a column titled "Employee Number", the destination list needs to have a column titled "Employee Number" in order for that data to be updated.

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

Value Pair

Description

list

The name of the SharePoint list to which you want to export the data.

onmultiple

Defines what you want the Operation to do if multiple listings are matched with the query. The only valid values are:

  • first: operates on the first row only.
  • error: throws an exception if multiple rows are returned.
  • all: performs the defined operation on all listings.

operation

The action you want to perform. Valid values for operation are:

  • Delete: Deletes an existing listing.
  • Insert: Inserts a new listing.
  • Update:Updates an existing listing.
  • Upsert: Inserts a new row into a database table if it does not exist, or updates a row if it already exists.

query

The query parameters to search for a listing record in the SharePoint list.

Example for using a SharePoint column:

[Title]==[titleNum]

  • [Title] = a SharePoint field
  • == is the operator (equals in this case)
  • [titleNum] = reference to a form field

NOTE: The syntax for this requires that the form field should not be an XPath.

The column used for the query ([titleNum]) should be either a promoted field ( a form field linked to a SharePoint Column so the values can be in sync) or a field present in the Winshuttle Process List Web Part. When a Winshuttle Composer solution is published, a Process List with a name corresponding to the name of the Composer solution is created in the Workflow SharePoint site.

Example for using a direct value

[Title]=='1'

  • [Title] = a SharePoint field
  • == is the operator (equals in this case)

See Using the Winshuttle Task List for Forms for more information about the Winshuttle Process List Web Part.

site

The SharePoint site that contains the list to which you want to export the data.

skipcopycolumns

Whether or not to skip copying of column values.

title

The value to which to set the Title SharePoint field on a newly inserted row.

Note: This value must be a promoted SharePoint List value.

Example

  • list – User Responsibilities
  • operation – Insert
  • query – [Title]==[titleNum]
  • site – http://acme.com/sv/FormEx
  • title – [$Process.Id]