SharePoint get list action

Use the Get list action to retrieve the list details from your SharePoint site.

Prerequisites

Ensure that you are authenticated before initiating any SharePoint action. For more details, see SharePoint authenticate action.

Procedure

  1. From the Actions pane, select SharePoint > List and list items > Get list and place it in the canvas.

    SharePoint get list
  2. In the Site field, select one of the following options:
    • Default site: The site name used during authentication is considered the default site.
    • Other site: If you want to choose a different site, specify the different site name.
  3. In the Filter field, select one of the following options:
    • All lists: Retrieve details of all the lists in your SharePoint site.
    • ID: Specify the list ID to retrieve details of this specific list.
    • Name: Specify a list name to retrieve details of this specific list.
  4. In the Session field, select one of the following options:
    • Session name: The name you provided for the session during authentication.
    • Variable: Select a variable which contains the session name.
  5. In the Matched records field, select a variable to store the list details.
The specified list details are retrieved and stored in the variable.
Note: The output is retrieved as a list of type Dictionary. To read an individual record (row) in this list, you need to loop through all the dictionary items using the Loop action and read or extract the records (rows) individually. For example, if the list is stored in the variable list_FolderDetails and it contains five records, then each record is passed to the Loop action to be processed one at a time. The loop reads the Name, URL, last modified time and Unique Id of each folder.SharePoint getFolder Actioni