Get List Item
Description
Get List Items plugin step gets items from the Generic List present in the specified site in SharePoint Online.
Prerequisites
You require the following permissions for app on Azure:
Permissions by Account Type
| Account Type | Permission Type | Permissions (from least to most privileged) |
|---|---|---|
| Work or School account | Delegated | Sites.Read.All, Sites.ReadWrite.All |
| Personal Microsoft account | Delegated | Sites.Read.All, Sites.ReadWrite.All |
Configuration
| No. | Field Name | Description |
|---|---|---|
| 1 | Step Name | Specify the name of the step. This name must be unique within a single workflow. This is a mandatory field. |
| Connection: | ||
| 2 | Client ID | Specify the Client ID of the SharePoint App. For information about creating a client ID, see Appendix: SharePoint: App Registration & Refresh Token Generation. The field data type is String. This is a mandatory field. |
| 3 | Accept value as variable/static | Select the checkbox if you want to enter the Refresh Token name in the Refresh Token field. If the checkbox is not selected, you can select the refresh token from the Refresh Token field. |
| 4 | Refresh Token | Specify or select the Refresh Token generated using the Client ID, which is created after registering the app in Azure AD. This is a mandatory field. |
| 5 | Test Connection | Verifies whether the connection is successfully established. Note: This connection will not work for variables from the previous step. The Test Connection button functions only with static values and environment variables. |
Input Tab
| No. | Field Name | Description |
|---|---|---|
| 1 | Site Relative URL | Select the SharePoint site-relative URL. Format: {Tenant Name}.sharepoint.com:/{SharePoint Site Path} Example: firstUser.sharepoint.com:/sites/TestingSite This is a mandatory field. Note: For the root site (Communication Site), you do not need to specify the {SharePoint Site Path}. |
| 2 | List Name/ID | Select the name or ID of the Generic List for which you want to retrieve items. This is a mandatory field. |
| 3 | Select Columns | Specify the names of the columns to retrieve if you want to get only specific columns. Use a comma (,) to separate multiple columns. By default, this step will retrieve all columns. If a specified column does not exist in the result set, it will be ignored. |
Output Tab
| Field Name | Description |
|---|---|
| JSON Output | Specify the output JSON in this field. The default value is JSONOutput. |