Action: Get item

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
Use dynamic url to the target SharePoint list	no	Choice	Available when using option 'On any site'. Allows you to dynamically set the target list URL
Dynamic list url	yes	String	Specify the target list URL (expression enabled value). The item will be added to this 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 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

Ein Bild, das Text, Screenshot, Diagramm, Zahl enthält.

KI-generierte Inhalte können fehlerhaft sein.

Examples:

Get items

output is usually used with Loop: apply to each action

Ein Bild, das Text, Screenshot, Zahl, Software enthält.

KI-generierte Inhalte können fehlerhaft sein.

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.