{{ transformations:SharePointListCommandAction.png}}
====== UPDATE/DELETE ROWS IN SHAREPOINT LIST======
Category: Workflow / External\\

\\ 
=====Description=====
This action updates or deletes rows in a SharePoint list.

\\ 
===== Action settings =====
^ Setting  ^ Description ^
|Connector <sup>*</sup>| A configured connector to a SharePoint site.  See [[connectors:sharepoint|SharePoint connector]] for details.|
|List<sup>1</sup>|Enter, or use the "Pick" button to select, the list to update/delete records within.  (The Pick list will populate once the appropriate SharePoint connector is assigned.)|
|Command|Select whether records are be updated or deleted within the SharePoint list.  Options:  //Update records// or //Delete records//.|
<sup>*</sup> Setting can be specified using a [[:parameters|parameter]].\\
<sup>1</sup> Setting can be specified using a [[:parameters|parameter]] or the first value of a column.

\\ 
====Update records settings====
^Setting  ^Description  ^
|Row IDs|Select the column in the current dataset that contains the row IDs for the records to be updated/deleted.|
|Lookup field behavior...  | See Remarks below. |
|Column names…|Choose how the column names will align between EasyMorph and SharePoint.  Options:  //Same as in EasyMorph//\\ (use the incoming dataset's column names) or //Other// (map the incoming dataset's columns names to the column\\ names of the selected //List//.|

\\ 
====Delete rows settings====
^Setting  ^Description  ^
|Delete mode|Select what rows will be deleted from the list.  Options:  //Only rows with IDs in// (and select the column in the dataset containing\\ the row IDs to be deleted) or //All rows in the list// (all rows in the list will be deleted).|

\\
===== Remarks =====
The action can automatically resolve linked values in lookup columns. When the "Expect values..." mode is selected, the action inserts the value(s) from the EasyMorph dataset, and links them to a lookup column (e.g., in another list). Only the values that exist in the lookup column are permitted. Otherwise, the action will fail.

Although, on large datasets, the automatic resolution can be slow. In this case, you can use the "Expect IDs..." mode. The EasyMorph dataset in this case must contain the IDs of the inserted values from the lookup column, not the values themselves.

\\ 
=====See also=====
  * [[transformations:exportsharepointlist|Export to SharePoint list]]
  * [[transformations:importsharepointlist|Import SharePoint list ]]
  * [[transformations:sharepointcommand|SharePoint command]]
  * [[connectors:sharepoint|SharePoint connector]]