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. Select one of the following options in the Site field:
    • Default site: This option sets the site name used during authentication as the default site.
    • Other site: This option allows you to specify a SharePoint different site.
  3. Select one of the following options in the Filter field:
    • All lists: This option retrieves details of all the lists in your SharePoint site.
    • ID: This option retrieves the details of a list based on its ID.
    • Name: This option retrieves the details of a list based on its name.
  4. Select one of the following options in the Session field:
    • Session name: This option allows you to enter the session name provided during authentication.
    • Variable: This option selects a string variable that contains the session name.
  5. Select a list variable to store the list details in the Matched records field.
When the automation executes, the details of the specified list are retrieved and stored in the list variable. You can use the Loop action to read or extract the contents by using the List type iterator. The List type iterator allows you to assign a dictionary variable for the data available in the list variable. You can then extract the list details of the SharePoint list using the key-value pair stored in the dictionary variable. Screenshot of SharePoint Get list action settings