Retrieves all items within a given SharePoint list using the Microsoft Graph API.
To use this procedure, make sure your agent has learned the Sharepoint Book (BDK).
Syntax
Below is a line-by-line overview of the automation syntax. Expand each line to learn more.
get some slist's items [whose [condition]]
When using it, it is very important to mark the item you are working with as a "slist" (Sharepoint list)
so that the Brain matches this procedure. It can optionally filter based on a given condition.
Base Syntax
get some slist's items
What does it do? This is the base syntax for the procedure.
Where does it go? This phrase should be written on a new line.
Is it required? ✅ Yes — This part of the phrase is required.
Does it require input data? ✅ Yes — The list from which to retrieve items must be specified for the slist.
Filter Condition Syntax
whose [condition]
What does it do? This is an optional clause used to specify a condition for filtering.
Where does it go? If used, this clause immediately follows the get some slist's items phrase on the same line.
Is it required? 🌟 No — This clause is optional in the syntax.
Does it require input data? ✅ Yes — This clause requires a condition (a filter expression) to be specified.
the include empty columns are
What does it do? Specifies whether to include empty columns in the table.
Where does it go? This phrase should be indented beneath the main procedure syntax.
Is it required? 🌟 No — This phrase is optional in the syntax.
Does it require input data? ✅ Yes — A boolean whether to include empty columns in the table must be specified for the include empty columns.
Default: False
Examples
1. Get the items in a list
get the list as the slist
get the slist's items
2. Get the items in a list filtered by a column
get the list as the slist
get the slist's items whose "Title" is "First Item"
3. Get the items in a list filtered by a column and include empty columns
get the list as the slist
get the slist's items whose "Title" is "First Item"
the include empty columns is "True"
