SharePoint on-premises - Delete items

Use the SharePoint on-premises - Delete items action A tool for building the processes, logic, and direction within workflows. Actions are the steps the workflow performs to complete a process. to delete items from a SharePoint on-premises list.

For more information about the SharePoint on-premises connector, go to SharePoint on-premises.

Before you begin: 

Jump to:

Configure the SharePoint on-premises - Delete items 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. Add the action to the workflow and 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 about authentication methods for SharePoint Online connections, see Authentication methods for SharePoint Online connections.

  1. Type a SharePoint site URL and click Retrieve lists. If you are retrieving the lists for a SharePoint subsite, type the URL of the subsite in the configuration. Parent sites do not automatically see all lists in child sites.

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

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

  2. Select the List name that has the item you want to delete.
  3. Select the Delete type.

SharePoint on-premises - Delete items actions 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 that enables workflows to communicate with external systems, services, or applications. It's required to pass data between the workflow and the indicated service, which could be a cloud service, business application, or content store.

SharePoint on-premises connection to connect to the SharePoint on-premises site that contains the list from which you want to delete items.

To refresh the available connections, click Refresh.

 (n/a)
Items to delete

SharePoint site URL

The URL of the SharePoint on-premises 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.

If you are retrieving the lists for a SharePoint subsite, type the URL of the subsite in the configuration. Parent sites do not automatically see all lists in child sites.

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

Text, Decimal, Integer, Boolean, DateTime, Collection
 

List name

The list in the selected site that you want to delete items from.

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

Text, Decimal, Integer, Boolean, DateTime, Collection
  Delete type

Select the delete type:

  • Items at root level but ignore folders: Deletes only items at the root level of the list.
  • Items at all levels but ignore folders: Deletes items in all levels but ignores folders.
  • Items and folders in all levels: Deletes items in all levels and all folders.
(n/a)
Conditions Add condition

Configure a condition to select which items to delete. Only the items that match the condition are deleted.

(n/a)
Condition builder When

Displays the items from the Column field of the selected list.

Note: 

The following columns are not supported in the Condition builder:

  • Calculated

  • Hyperlink

  • Managed Metadata

  • Multiple lines of text

 Text, Decimal, Integer, Boolean, DateTime, Collection
  Operator

How the item from the When drop-down and Value are compared. Select from the drop-down.

The operators available in the drop-down depend on the data type of the item selected from the When drop-down.

 (n/a)
  Value

The value you are expecting in the column (field) specified for When.

The data type of Value must match the data type of the item selected in the When drop-down.

 (varies)
  Summary A description of the condition statement. (n/a)
Output Result

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

  • Outcome: Boolean variable to store the outcome of the action. Returns Yes if all of the specified files are deleted successfully. Returns No, even if one file deletion fails.
Object