User Tools

Site Tools


transformations:sharepointlistcommand

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 * A configured connector to a SharePoint site. See SharePoint connector for details.
List1Enter, 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.)
CommandSelect whether records are be updated or deleted within the SharePoint list. Options: Update records or Delete records.

* Setting can be specified using a parameter.
1 Setting can be specified using a parameter or the first value of a column.


Update records settings

Setting Description
Row IDsSelect 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 modeSelect 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/sharepointlistcommand.txt · Last modified: 2023/01/29 17:20 by dmitry

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki