Use the Get list item (s)
action to retrieve the list item details from a list in your SharePoint site.
Procedure
-
From the Actions pane, select and place it in the canvas.
-
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.
-
In the List name field, specify the list name.
-
In the Filter field, choose one of the following options:
- All list items: Retrieve details of all the list items
in the SharePoint list.
- List item ID: Specify the list item ID to retrieve
details of this specific list item.
- List item title: Specify a list item title to retrieve
details of this specific list item that contains the title.
- Folders: Specify a folder path to
retrieve all items within, including files and subfolders (and their
contents).
-
In the Download file item(s) field, select one of the
following options:
- No: Select this option if you do not want to download
the file items.
- Yes: Select this option and specify a destination
folder path to download the file items within the folder path.
-
In the Download image column(s) field, select one of the
following options:
- No: Select this option if you do not want to download
the image attached to the list item.
- Yes: Select this option and specify a destination
folder path to download the image attached to the list item.
-
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.
-
In the Use display labels in output, select one of the
following:
- Yes: Select this option to display the labels of the
list item entry in the output variable.
- No: Select this option to display the column names of
the list item entry in the output variable.
-
In the Matched records field, select a variable to store the
list item details.
Results
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.
