Get items action allows to get items from a SharePoint list or library and use them e.g. in a loop control.
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 and specifying the list in 'Select List or Library' dialog or typing a server relative URL to a list. |
| 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 adding item on the list from the current site is available.
Example of Get items action configuration on the current site
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 |