# Create rows in SharePoint list action (batch)

This action creates multiple rows in a SharePoint list you specify.

# Input fields

Field Description
Site name Provide the name of the SharePoint site to which you plan to connect. If left blank, Workato connects to your default home site, as specified in your connection settings. The site name is located in the URL of the site page. For example, if the URL is https://company-name.sharepoint.com/sites/product, the site name is product.

If you plan to connect to a different site, you can provide the absolute URL to override the base URL. For example, if the input is https://company-name.sharepoint.com/teams/product, Workato connects to the provided input.

Alternatively, you can provide the absolute URL to connect to a different site. For example, entering https://company-name.sharepoint.com/teams/product connects Workato to the specified site directly.
List Specify the list where you plan to create rows.
Batch Specify the batch of rows you plan to create. Each row should contain the fields you plan to populate.

# Output fields

The output datatree contains the details of the newly created rows.

Field Description
Content type ID (ContentTypeId) The identifier for the content type of the item.
Name (title) The name or title of the item.
Approver comments (OData__ModerationComments) Comments added during the approval process.
File type (File_x0020_Type) The type of file (document, spreadsheet, etc.).
Color (OData__ColorHex) The color code associated with the item.
Color tag (OData__ColorTag) The tag or label indicating a specific color.
Emoji (OData__Emoji) The emoji associated with the item.
Compliance asset ID (ComplianceAssetId) The identifier for compliance purposes.
Profile picture (ProfilePicture) The URL or reference to the profile picture.
ID (ID) The unique identifier or title of the item.
Content type (ContentType) The content type of the item (document, list item, and more).
Modified (Modified) The date and time when the item was last modified.
Created (Created) The date and time when the item was created.
Created by (Author) The user who created the item.
Modified by (Editor) The user who last modified the item.
Has copy destinations (…__HasCopyDestinations) Indicates if the item has copy destinations.
Copy source (OData__CopySource) The source from which the item was copied.
Ows hidden version (owshiddenversion) The hidden version number of the item.
Workflow Version (WorkflowVersion) The version of the workflow associated with the item.
UI Version (OData__UIVersion) The user interface version of the item.
Version (OData__UIVersionString) The version of the item (string representation).
Attachments (Attachments) Indicates if the item has attachments.
Approval Status (OData__ModerationStatus) The approval status of the item.
Edit (Edit) The edit link for the item.
Title (LinkTitleNoMenu) The title of the item without a menu link.
Title (LinkTitle) The title of the item with a menu link.
Title (LinkTitle2) The alternative title of the item with a menu link.
Select (SelectTitle) The select title of the item.
Instance ID (InstanceID) The unique identifier of the instance.
Order (Order) The order of the item.
GUID (GUID) The globally unique identifier of the item.
Workflow Instance ID (WorkflowInstanceID) The identifier of the workflow instance associated with the item.
URL Path (FileRef) The server-relative URL path of the item.
Path (FileDirRef) The server-relative path of the folder containing the item.
Modified (Last_x0020_Modified) The date and time when the item was last modified.
Created (Created_x0020_Date) The date and time when the item was created.
Item type (FSObjType) The type of the item in the document library (file, folder, and more).
Sort type (SortBehavior) The sorting behavior applied to the item.
Effective permissions mask (PermMask) The permissions mask indicating effective permissions for the item.
Principal count (PrincipalCount) The number of principals with permissions on the item.
Name (FileLeafRef) The leaf name of the file (name without path).
Unique ID (UniqueId) The unique identifier of the item.
Document parent identifier (ParentUniqueId) The identifier of the parent document in a document set.
Client ID (SyncClientId) The identifier used for synchronization purposes.
ProgId (ProgId) The programmatic identifier of the file type.
ScopeId (ScopeId) The identifier of the scope of the item.
HTML file type (HTML_x0020_File_x0020_Type) The HTML file type associated with the item.
Edit menu table start (…a__EditMenuTableStart) The start of the edit menu table.
Edit menu table start (…__EditMenuTableStart2) The alternative start of the edit menu table.
Edit menu table end (OData__EditMenuTableEnd) The end of the edit menu table.
Name (LinkFilenameNoMenu) The filename without a menu link.
Name (LinkFilename) The filename with a menu link.
Name (LinkFilename2) The alternative filename with a menu link.
Type (DocIcon) The icon representing the document type.
Server relative URL (ServerUrl) The server-relative URL of the item.
Encoded absolute URL (EncodedAbsUrl) The encoded absolute URL of the item.
File name (BaseName) The base name of the file (filename without extension).
Property bag (MetaInfo) The metadata information associated with the item.
Level (OData__Level) The level of the item in a hierarchy.
Is current version (OData__IsCurrentVersion) Indicates if the item is the current version.
Item child count (ItemChildCount) The number of child items associated with the item.
Folder child count (FolderChildCount) The number of child folders associated with the item.
Restricted (Restricted) Indicates if the item is restricted.
Originator ID (OriginatorId) The identifier of the originator of the item.
NoExecute (NoExecute) Indicates if the item should not be executed.
Content version (ContentVersion) The version of the content.
Label setting (OData__ComplianceFlags) The compliance flags associated with the item.
Retention label (OData__ComplianceTag) The retention tag applied to the item.
Retention label (Applie…plianceTagWrittenTime) The date and time when the retention tag was applied.
Label applied by (OData__ComplianceTagUserId) The user who applied the retention tag.
Item is a record (OData__IsRecord) Indicates if the item is a record.
Access policy (AccessPolicy) The access policy applied to the item.
VirusStatus (OData__VirusStatus) The virus scan status of the item.
VirusVendorID (OData__VirusVendorID) The identifier of the virus scanning vendor.
VirusInfo (OData__VirusInfo) The information related to the virus scan.
App created by (AppAuthor) The application that created the item.
App modified by (AppEditor) The application that last modified the item.
Total size (SMTotalSize) The total size of the item.
Last modified date (SMLastModifiedDate) The date and time when the item was last modified.
Total file stream size (SMTotalFileStreamSize) The total size of the file stream.
Total file count (SMTotalFileCount) The total number of files.
-Comment settings (OData__CommentFlags) The comment settings associated with the item.
-Comment count (OData__CommentCount) The number of comments associated with the item.
Success Indicates the success of the operation.
Error Indicates whether the operation resulted in an error.
List size The list size.
List index The list index.


Last updated: 7/25/2024, 5:12:40 PM