Get items action allows to get items from a SharePoint list or library and use them e.g. in a loop control.
Example of Get items action configuration on the current site
For more information about Action Builder read Action Builder introduction article.
To configure the action Get items additional properties should be specified:
Configuration
| Property | Required | Type | Description |
|
List or library |
yes | Choice | A list or library where to get items from SharePoint. It is possible to select: - from the current site, by selecting the 'On current site' option. The drop-down shows all available lists on the site. - from any site, by selecting 'On any site' option, choosing the site in the drop-down or typing a server relative URL to the site and then selecting a list or library in 'List or Library' drop-down |
| Query | no | String | A valid CAML query string to filter the items in the list/library to return. If you leave it blank, it will return all items from the selected list/library |
Availability
| Modern Forms | List Actions | Scheduled/Triggered Actions |
| ✓ | ✓ | ✓* |
* In Scheduled/Triggered actions only retrieving items from the list on the current site is available.
Output
| Output Parameter | Type | Description |
| Items | object | The output of this action is an array of SharePoint list items. |
| HtmlTable | object | The output of this action is an array of SharePoint list items in the table format |
Examples:
Get items output is usually used with Loop: apply to each action
To retrieve all available properties, you can turn on Debug mode in Action builder, then open Console tab in developer tools (F12) in the SharePoint site and execute Get items action.
In order to use this output to get value of the column, open Expression builder as Assignment expression and add this placeholder:
[[@Actions.Get_Items.Items]][0].Field1
This expression retrieves the Field1 field value from the first item in the array.