Update SharePoint List

The Update SharePoint list plug-in 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.

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: replaces an existing listing.
query	The query parameters to search for a listing record in the SharePoint list. Example: [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.
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.

Example

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