Microsoft GraphList SharePoint list items
BetaReads data
Lists the rows of a SharePoint list, with the columns you choose.
Settings
| Setting | What it is |
|---|---|
| ConnectionRequired | The Microsoft Graph connection the step signs in with. |
| Site idRequired | The id Get SharePoint site answered — host name, site GUID and web GUID. |
| ListRequired | The list's id, or its title. |
| Columns | Internal column names, comma-separated — a space is _x0020_. Leave empty for every column. |
| Filter | Filters best on an indexed column, and on one indexed column at a time. |
| Allow filters on columns that are not indexed | Without an index SharePoint scans the whole list, and on a large list it may refuse the read at random — index the column for a read that always works. |
| Items per call | 1 to 999. |
| Fetch every page | Follows Graph's own next-page link. |
| Stop after | Pages — at most 50. |
| Cursor | Paste a previous run's Next cursor to read the page after it. |
Technical details
| Key | Value |
|---|---|
connection | texta connection id from `requires.connections` (provider `microsoft-graph`) |
siteId | text |
listId | text |
fields | text |
filter | text |
allowNonIndexed | true/false, by default false |
top | number, by default 100 |
returnAll | true/false, by default false |
maxPages | number, by default 10 |
cursor | text |
Output
| Field | Type |
|---|---|
items | array |
countItems in this answer | number |
hasMoreMore items are waiting behind this page | boolean |
nextCursorCursor for the next page | string |
Sample output, and the expression for each field
- count0
- hasMorefalse
- items[]
- nextCursor""
Errors
When a step of this node stops a run, the run page shows a code. Look it up:
Example step
The step as a flow file holds it. Replace each value in <…>.
{
"config": {
"allowNonIndexed": false,
"connection": "<connection id>",
"cursor": "",
"fields": "",
"filter": "",
"listId": "<list>",
"maxPages": 10,
"returnAll": false,
"siteId": "<site id>",
"top": 100
},
"label": "List SharePoint list items",
"type": "graph.listListItems",
"version": 1
}