SharePoint Online - Create an item

Use the SharePoint Online - Create an item action A tool for building the processes, logic, and direction within workflows. to create an item with the specified fields in a list in SharePoint Online.

For more information about the SharePoint Online connector, go to SharePoint Online.

Before you begin: 

Jump to:

Configure the SharePoint Online - Create an item action

Important: Before inserting variables in the action configuration, you must manually type or select the values and populate other dependent fields in order to retrieve the output data. Once configured, you can insert variables to the required fields.

  1. Open the action configuration panel. For more information, see Add an action to the workflow.

  2. Select a Connection. If you do not have a connection, see Add a connection.
    Note:  Only the connections created with the List and libraries authentication method are available in the drop-down list. For more information, see Connectors.
  1. Type a SharePoint site URL and click Retrieve lists.

    2. Example: https://domain.sharepoint.com/sites/hr

    All the lists in the specified site are displayed in the List name field drop-down list.

  1. In List name, select the list you want to create the item in. The Add field button is enabled to enter values for the columns/fields of the created item. If the selected list has mandatory columns they are displayed by default to enter a value.
  2. Specify values for the mandatory fields/columns that are displayed.

SharePoint Online - Create an item action fields and settings

Important: Before inserting variables in the action configuration, you must manually type or select the values and populate other dependent fields in order to retrieve the output data. Once configured, you can insert variables to the required fields.

Section Field Description Variable types
(unlabeled)

Connection Credentials and other settings required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.

SharePoint Online connection to connect to the SharePoint Online site.

To refresh the available connections, click Refresh.

 (n/a)
New item

SharePoint site URL

The URL of the SharePoint Online site that has the list or document library you want to use.

To retrieve the lists for the SharePoint site URL, type the SharePoint site URL and click Retrieve lists.

Example: https://domain.sharepoint.com/sites/hr

Text, Decimal, Integer, Boolean, DateTime, Collection
 

List name

The list in which you want to create the item.

The lists and document libraries within the site specified in SharePoint site URL are displayed in the drop-down list.

When a List name is selected the Add fields button is displayed to select fields for the item you are creating.

Text, Decimal, Integer, Boolean, DateTime, Collection
 

Folder path

The destination folder to create the item in.

If a folder path is not specified, the item is created at the root level of the list.

Boolean, Collection, DateTime, Decimal, Integer, Text
  Add fields

(Displayed only when a List name is selected.)

Displays selections to select and add columns (fields) that you want to populate for the item.

  1. Click Add fields to view fields for the selected list.
  2. Select each field you want and then click Add.

  3. For each added field, specify the required value.

See Valid values for added fields, by column type.

The fields you add are displayed for you to enter the value. The item is created in the list with these values populated in the columns.

The values you enter must meet SharePoint Online formatting requirements for the related column type. See, Valid values for added fields, by column type.

Selection

Description

Filter options ()

Type in text to filter the list of fields.

Select all

Selects all fields.

Cancel

Discards field selections and hides the fields available for selection.

Add

Adds the selected fields.

varies
Output

Result

Stores the result of the action in an object with the following variables:

  • Item ID: Integer variable to store the ID of the created item.
  • Item GUID: Text variable to store the GUID of the created item.
  • Item URL: Text variable to store the URL of the created item.

Object

The values you enter for the added fields must meet the following formatting requirements:

Column type (SharePoint)* Value entry guidance (Nintex Automation Cloud)

Choice

<choice 1>

Example: Blue

Supported variable A placeholder that stores changes each time the workflow runs, such as the information entered in a form, or the name of a file. You can also create variables to store information you use in the workflow, such as an email address. types: Text

Note: Multiple-selection columns cannot be updated using the action Update an item. That is, Choice type SharePoint columns configured with the "Checkboxes (allow multiple selections)" option for "Display choices using" setting, cannot be updated.

Single value only. New columns are configured with the "Display choices using" option of "Drop-down Menu."

Currency

<decimal value>

Example: 25.50

Supported variable types: Decimal

Date and Time

<date or date/time>

Example: 20170602

Supported variable types: DateTime

For updates to date-only columns, removes time.
Hyperlink or Picture

<URL>,<description>

Example: https://www.nintex.com,Nintex

Supported variable types: Text

Lookup

<ID of list item in selected list>

Example: 1

Supported variable types: String
Managed Metadata

<unique identifier of the term in the term store>

Example: 883f304208f84f78bbe6d48d7e34c494

Supported variable types: Text

Multiple lines of text

<text and/or HTML>

Example: <b>ACME</b> invoice

OR

ACME invoice

(HTML is supported when "Enhanced rich text" is enabled for the SharePoint column.)

Supported variable types: Text

Number

<integer>

Example: 1

Supported variable types: Integer

Person or Group

<person or group ID>; <person or group ID>

Supports email address and display name values.

Example: David Smith; David.Smith@abc.com

Supported variable types: Integer, Text

Single line of text

<text>

Example: ACME Invoice

Supported variable types: Text

Task Outcome

<choice 1>

Example: Approved

Supported variable types: Text

Single value only. Typically used to update task lists.

Yes/No

<true/false>

Example: True

Supported variable types: Boolean

For more information about column types, see List and library column types (Microsoft article).