| Step Details | |
| Introduced in Version | 5.0.0 |
| Last Modified in Version | 9.4 |
| Location | Integrations> SharePoint Document Library |
After the SharePoint Module has been installed and a SharePoint List/Document Library has been configured, the List/Document Library can be interacted with using Decisions steps in a Flow. The Get All Documents Step enables Users to retrieve a list of Documents from an integrated SharePoint List or Document Library.
Prerequisites
- This Step will not appear in the Flow Designer until the SharePoint Module is installed, and the following requirements have been fulfilled:
- Users must also have access to a SharePoint site.
- For v9 Users: Add a Project Dependency.
Sharepoint Limitations
SharePoint has inherent limitations in its capacity to handle files. They are:
- Only 5,000 files can be displayed in a view.
- Only 300,000 files can be stored in a library before performance issues arise.
- Unique document permissions are limited to 50,000 items per list.
Properties
Inputs
| Property | Description | Data Type |
|---|---|---|
| Folder Path | This input sets the Folder from which files will be retrieved and is available for v9.4+. If set to null, ignore, or empty string, it will return files from the root of the integrated SharePoint Document Library. | String |
Folder Path Input
Please note that this Input only applies to the "Get All Documents" Step generated after adding a SharePoint Document Library, not a List. The List version of this Step should not show the Input.
Outputs
| Property | Description | Data Type |
|---|---|---|
| Error Message | Displays an Error Message. | String |
| Items | Displays a list of documents from the connected Document Library/List. | -- |
Examples
Using Get All Items from a SharePoint List
- In the Flow Designer, navigate to Integration > SharePoint > Name of List and add the Get All Items Step to the Workspace.
.png)
- Connect the Error and Success paths to the End Step. Then click Save to save changes to the Flow.
- Click Debug.
- After the Debugger runs, click the Get All Items Step. Click Execution 1 and select View Output Data.
- The Output Data should display all the list items from the integrated SharePoint List.
Using the Get All Documents Step from a SharePoint Document Library
Step Changes
| Description | Version | Date | Developer Task |
|---|---|---|---|
| All documents within a SharePoint Folder can now be fetched with a new setting on the Get All Documents Step. | 9.4 | November 2024 | [DT-037434] |
Related Information
Forum Posts:
.png)