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

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.

 

• Related Articles

• Teamsware Studio Update 29.01.2026

  Bug fixes & improvements Modern Forms Version 1.3.108 Improved Get items action with an option 'Use dynamic url to the target SharePoint list', allowing dynamic setting of the list URL for item operations Improved performance evaluation of ...

• Teamsware Studio Update 18.07.2025

  Import Information Send internal email action retirement Due to the retirement of the SharePoint SendMail API, 'Send internal email' action will no longer work in SharePoint Online after October 31, 2025. To keep send email functionality, please ...

• Action Builder Introduction

  The Teamsware Studio Action Builder is a tool that allows you to specify actions which are executed in consecutive order. You can build powerful workflows triggered from a form button, on form load, from a list view, scheduled or event triggered on a ...

• Action: Get image data

  Get image data action allows you to retrieve the image data information such as geolocation and the size of the image. Example of Get image data action configuration on the current site For more information about Action Builder read Action Builder ...

• Teamsware Studio Update 16.01.2025

  New Features Selective Deployment for App deployment Selective deployment is available on creating or updating teamsware App deployment service on the Deployments tab. Bug fixes & improvements Modern Forms Version 1.3.74 Added ability to search lists ...