SharePoint Update list item action

Use the Update list item action to update a list item value in an existing list in your SharePoint site.

This procedure shows how to configure a Update list item action to update a list item value in an existing list that is available on SharePoint Online site. This configuration uses Microsoft Graph API for the Authenticate action and SharePoint discovery assistant to retrieve the list details.

Procedure

  1. Go to SharePoint > List and list items and double-click Update list item to add the action.
  2. Click Use SharePoint discovery assistant and perform the following steps in the Connect to SharePoint modal to retrieve the lists available in your SharePoint site.
    For more information on the SharePoint discovery assistant, see SharePoint discovery assistant.
    1. Click Pick and follow the prompts in Pick an OAuth connection modal to select the OAuth connection.
      Ensure that you select the same connection that you had used for the Authenticate action.
    2. Select Microsoft Graph API in API.
      If you choose SharePoint REST API, the connection fails.
    3. Enter your SharePoint subdomain in Subdomain.
    4. Enter your SharePoint site name in Site name.
    5. Click Connect to connect to the SharePoint and retrieve the list details.
    6. Select the appropriate list where you want to make the changes in the Select a list modal.
      The list details are auto-populated in the List name/List Id and Columns fields respectively.
      Note: The SharePoint discovery assistant auto-populates the Columns section with only the display columns enabled on the SharePoint site.
  3. Enter the item ID of the list item in List item ID.
  4. Click Edit from the vertical ellipsis menu of each column entry and modify the values as per your requirement.
  5. Click Add entry option to add new columns with column name, column type and value.
    Note:

    The Update list item action does not support the following column types:

    • Multiple lines of text with Rich text with pictures
    • Lookup
    • Hyperlink
    • Image
    • Location
    • Currency with calculation value
    • Person or Group
    • Managed metadata
  6. Select one of the following options in the Session field:
    • Session name: Enter the name you provided for the session during authentication.
    • Variable: Select the session variable that you configured for the session during authentication.
  7. Click Save to save the configuration.

    SharePoint update list item
When run the bot, the system updates an existing list item with the new parameters in the specified SharePoint list.