| Both sides previous revisionPrevious revision | |
| transformations:sharepointlistcommand [2023/01/29 17:20] – dmitry | transformations:sharepointlistcommand [2026/06/23 22:53] (current) – note about Update rows failure (in Remarks) craigt |
|---|
| ^ Setting ^ Description ^ | ^ Setting ^ Description ^ |
| |Connector <sup>*</sup>| A configured connector to a SharePoint site. See [[connectors:sharepoint|SharePoint connector]] for details.| | |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.)| | |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//.| | |Command|Select whether records will 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>*</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. | <sup>1</sup> Setting can be specified using a [[:parameters|parameter]] or the first value of a column. |
| |Row IDs|Select the column in the current dataset that contains the row IDs for the records to be updated/deleted.| | |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. | | |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//.| | |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 column names to the column\\ names of the selected //List//.| |
| |
| \\ | \\ |
| \\ | \\ |
| ===== Remarks ===== | ===== 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. | 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. | 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. |
| | |
| | In //Update rows// mode, this action will fail if attempting to update a multiple-choice column with illegal values. |
| |
| \\ | \\ |
