共用方式為


SharePoint

SharePoint helps organizations share and collaborate with colleagues, partners, and customers. You can connect to SharePoint Online or to an on-premises SharePoint 2016 or 2019 farm using the On-Premises Data Gateway to manage documents and list items.

This connector is available in the following products and regions:

Service Class Regions
Logic Apps Standard All Logic Apps regions
Power Automate Standard All Power Automate regions
Power Apps Standard All Power Apps regions
Contact
Name Microsoft
URL Microsoft LogicApps Support
Microsoft Power Automate Support
Microsoft Power Apps Support
Connector Metadata
Publisher Microsoft
Website https://products.office.com/sharepoint/collaboration

Notes

  • Power Automate
    • Power Automate flows for lists are only supported in generic lists and generic document libraries. Custom list and library templates are currently not supported, including but not limited to lists such as Announcements, Contacts, Events, and Tasks.
  • Power Apps
    • If the Customize forms option isn't available or doesn't work correctly for your list, it might contain data types that Power Apps doesn't support.
    • Custom forms for lists are only supported in generic lists and generic document libraries. Custom list and library templates are currently not supported, including but not limited to lists such as Announcements, Contacts, Events, and Tasks.
    • Custom forms for document libraries only supports editing custom metadata. Editing or managing file(s) is not supported.
    • Custom forms cannot be moved to a different list or environment after they have been created. However, it is possible to set the environment in which Power Apps will save new custom forms.
  • Triggers and actions that are marked as "deprecated" are no longer actively maintained. While they are still present in this connector, it is strongly recommended to not use them in any new applications or solutions.

Known issues and limitations

  • Conditional Access policies, such as multi-factor authentication or device compliance policies, may block access to data via this connector. Please see Microsoft Entra ID Conditional Access documentation for more details.
  • If you are getting an incomplete data set or you are not able to return accurate results from the SharePoint list, it might be because of delegation limits. For more details, please learn more here.
  • For Flows that use the 'For a selected item' or the 'For a selected file' trigger, only those that are part of the default environment in Power Automate are listed within the SharePoint Automate menu.
  • Certain built-in SharePoint flows, such as Request sign-off, will not be listed in the Power Automate portal and are not editable.
  • It is not possible to set sensitivity labels on a file via this connector.
  • If you see the error "CannotDisableTriggerConcurrency" while using SharePoint triggers in a flow, please note that once you enable and disable the concurrency control, it cannot be undone as stated here. To workaround this issue, please export the flow and edit the JSON file to remove the "concurrency control" part. That way the concurrency option will be disabled during the re-import of the flow.
  • Guest user accounts can't view or retrieve drop-down list information in connector operations.
  • Updates to term set labels will not be automatically reflected in a connected flow or app. To work around this issue, please directly edit the affected list item from the list to force a refresh of the term set label.
  • The Extract Folder V2 action may lead to character distortion during the extraction process when special characters are involved. To avoid this issue, please use a modern zip archive tool or library that adheres to the standard zip specification. This means it should use the UTF-8 encoding process as well as set the language encoding header flag when it constructs the zip file. (Example of such a library - .NET's Zip Archive SDK) Please note that this is not a limitation in the connector’s ability to support special character zips in the operation, but rather an issue with the archive tool leading to this problem.
  • For lists or libraries that contain a period anywhere within the list name (example: MySharePoint.List), using this list’s name as a dynamic value and passing that in as the “List Name” parameter will cause an error. In this case, select the list from the dropdown menu in Power Automate, or if a dynamic value must be used, input the list’s ID in the “List Name” value instead.
  • List item attachments are supported up to 90MB in size.

SharePoint Image column in Power Apps limitations

  • SharePoint image types may display with Full, Large, Medium, and Small modifiers. (e.g., ThisItem.'Item Photo'.Small) The Small, Medium, and Large sized images are created on demand and temporarily cached.  An image that has been cached too long will be removed and will be regenerated on demand.
  • Only the following image formats listed here are supported.
  • Image files up to 90MB in size are supported for upload via Power Apps to a list.
  • Power Apps generally refreshes image meta-data every 30 seconds.  If you are authoring an application and want to immediately refresh the images, choose the "..." item on the data source to refresh the data.
  • Images stored in a collection will not be rendered correctly.  It is best to access them directly with a Filter expression.
  • If you create an app from SharePoint or add a gallery control that connects to a SharePoint list with an image column, images may appear in the gallery even if the image column is hidden in the list. You can use the Power Apps fields list to show or hide any image field.

Power Apps data type mappings

Power Apps SharePoint
Boolean Yes/No (checkbox)
DateTime Date and Time
Image Hyperlink or Picture, Image
Complex Choice, Lookup, Person or Group, Task Outcome, External Data, Managed Metadata
Number Number, Currency, ID
Text Single line of text, Multiple lines of text, Calculated

Note

SharePoint types that map to Power Apps as complex often have subfields that map to basic types such as text and number.

Power Apps delegable functions and operations for SharePoint

The following Power Apps operations, for a given data type, may be delegated to SharePoint for processing (rather than processing locally within Power Apps).

Operation/Function Number Text Boolean DateTime Complex [2]
Filter Yes Yes Yes Yes Yes
Sort Yes Yes Yes Yes No
SortByColumns Yes Yes Yes Yes No
Lookup Yes Yes Yes Yes Yes
= Yes Yes Yes Yes Yes
<, <=,<>, >, >= Yes [3] No No Yes Yes
StartsWith - Yes - - Yes
IsBlank - No [4] - - No

Delegation notes

  • Expressions that are joined with And or Or are delegable to SharePoint. Not isn't delegable.
  • SharePoint supports delegation of complex types by deferring the decision for delegation to the subfield involved. Check the type of the subfield being used on the complex type and then check this table for delegation capabilities. Note that only Email and DisplayName are delegable in the Person data type.
  • The SharePoint ID field for a table is a number field in Power Apps. However, SharePoint only supports the equal ('=') operation for delegation on an ID field.
  • A formula such as Filter(..., IsBlank(CustomerId)) won't delegate to SharePoint. However, that formula is semantically close to Filter(..., CustomerId = Blank()), which will delegate to SharePoint. These formulas aren't equivalent because the second formula won't treat the empty string ("") as empty. However, the second formula might work for your purposes. On SharePoint, this approach will work for the equals operator ("=") but not the operator for not equals ("<>").
  • SharePoint system fields are not delegable. These fields include:
    • ​​​​​​Identifier
    • IsFolder
    • Thumbnail
    • Link​
    • Name
    • FilenameWithExtension
    • Path
    • FullPath
    • ModerationStatus
    • ModerationComment
    • ContentType
    • IsCheckedOut
    • VersionNumber
    • TriggerWindowStartToken
    • TriggerWindowEndToken

General Limits

Name Value
Maximum number of megabytes being transferred to/from the connector within a bandwidth time interval (per connection) 1000
Bandwidth time interval (in miliseconds) 60000

Creating a connection

The connector supports the following authentication types:

Default Parameters for creating connection. All regions Not shareable

Default

Applicable: All regions

Parameters for creating connection.

This is not shareable connection. If the power app is shared with another user, another user will be prompted to create new connection explicitly.

Name Type Description Required
Gateway gatewaySetting On-prem gateway (see https://docs.microsoft.com/data-integration/gateway for more details
Authentication Type string Authentication type to connect to your database
Username securestring Username credential True
Password securestring Password credential True

Throttling Limits

Name Calls Renewal Period
API calls per connection 600 60 seconds

Actions

Add attachment

Adds a new attachment to the specified list item.

Approve hub site join request

Approve hub site join request. This will return an approval token that can be used to complete the join request using the join hub site action.

Cancel hub site join request

Cancel hub join request. If applicable, you should specify the same Approval Correlation Id as used in the "Set hub site join status to pending" action.

Check if the scheduled version of the item is published [DEPRECATED]

Returns the result in the output variable IsFilePublished.

Check in file

Check in a checked out file in a document library, which makes the version of the document available to others.

Check out file

Check out a file in a document library to prevent others from editing the document, and your changes from being visible until the documented is checked in.

Copy file

Copies a file. Works in a similar way to the "Copy to" command in SharePoint libraries. Returns information about the new file after copy.

Copy file (deprecated)

Copies a file to a SharePoint site.

Copy folder

Copies a folder. Works in a similar way to the "Copy to" command in SharePoint libraries. Returns information about the new folder after copy.

Create file

Uploads a file to a SharePoint site. Make sure to pick an existing library.

Create item

Creates a new item in a SharePoint list.

Create new document set

Creates a new document set list item.

Create new folder

Creates a new folder or folder path.

Create sharing link for a file or folder

Create sharing link for a file or folder.

Delete attachment

Deletes the specified attachment.

Delete file

Deletes the file specified by the file identifier.

Delete item

Deletes an item from a SharePoint list.

Discard check out

If you check out a file and don’t make changes to it, or you make changes that you don’t want to keep, you can simply discard the checkout, rather than saving the file. If your organization tracks versions, a new version is created each time you check a file back into the library. By discarding the checkout, you can avoid making new versions when you haven’t made any changes to the file.

Extract folder

Extracts an archive file into a SharePoint folder (example: .zip).

Generate document using Microsoft Syntex (preview)

Use this action to create documents based on modern templates from Microsoft Syntex. This preview requires a Syntex license. Pricing is subject to change. For more info see: https://docs.microsoft.com/en-us/microsoft-365/contentunderstanding/content-assembly.

Get all lists and libraries

Get all lists and libraries.

Get attachment content

Returns file contents using the file identifier. The contents can be copied somewhere else, or be used as an attachment.

Get attachments

Returns the list of attachments for the specified list item. You can add a "Get attachment content" step and use the "File identifier" property returned by this action to get to the contents of the file.

Get changes for an item or a file (properties only)

Returns information about columns that have changed within a given time window. Note: The list must have Versioning turned on.

Get file content

Gets file contents using the file identifier. The contents can be copied somewhere else, or be used as an attachment.

Get file content using path

Gets file contents using the file path.

Get file metadata

Gets information about the file such as size, etag, created date, etc. Uses a file identifier to pick the file. Use "Get file properties" action to get to the values stored in the columns in the library.

Get file metadata using path

Gets information about the file such as size, etag, created date, etc. Uses a file path to pick the file. Use "Get file properties" action to get to the values stored in the columns in the library.

Get file properties

Gets the properties saved in the columns in the library for the item specified by the item id. You can add a "Get file content" step and use the "File identifier" property returned by this action to get to the contents of the file. When using this with the On-Premises Data Gateway, the name of the library to connect to may need to be entered manually.

Get files (properties only)

Gets the properties saved in the columns in the library for all folders and files stored in the library. You can also filter down to the items that match a condition. An "Apply to each" section is usually used to work with the output from this action. When using this with the On-Premises Data Gateway, the name of the library to connect to may need to be entered manually.

Get folder metadata

Gets information about the folder. Uses a file identifier to pick the folder.

Get folder metadata using path

Gets information about the folder. Uses a folder path to pick the folder.

Get item

Gets a single item by its id from a SharePoint list.

Get items

Gets items from a SharePoint list.

Get list views

Gets views from a SharePoint list.

Get lists

Gets SharePoint lists from a site.

Grant access to an item or a folder

Grant access to an item or a folder in SharePoint to specific people.

Join hub site

Join the requested site to the hub site. An Approval Token is required to complete the join successfully if that hub requires approval. If applicable, you should specify the same Approval Correlation Id as used in the "Set hub site join status to pending" action.

List folder

Returns files contained in a SharePoint folder.

List root folder

Returns files in the root SharePoint folder.

Move file

Moves a file. Works in a similar way to the "Move to" command in SharePoint libraries. Returns information about the new file after move.

Move folder

Moves a folder. Works in a similar way to the "Move to" command in SharePoint libraries. Returns information about the new folder after move.

Resolve person

Returns a single matching user value so it can be assigned to a column of type person. If there are no matches, or multiple matches, this action will error out.

Send an HTTP request to SharePoint

Construct a SharePoint REST API to invoke. Note – This action may execute any SharePoint REST API you have access to. Please proceed with caution.

Set content approval status

Sets the content approval status for an item in a list or library that has content approval turned on. You must provide an ETag for pages and files. You can get the ETag using the Get File Metadata action. This action is only available for SharePoint Online and SharePoint 2019.

Set hub site join status to pending

Set the requested site's hub join request status to pending. The Approval Correlation Id is an optional parameter that helps SharePoint identify a particular hub join request. The requesting site can only have one pending request at a given time.

Stop sharing an item or a file

Delete all links giving access to an item or a file and remove all people with direct access except for owners.

Update file

Updates the contents of the file specified by the file identifier.

Update file properties

Updates the properties stored in columns in a library for the item specified by the item id. Use "Update file" action to update file contents. When using this with the On-Premises Data Gateway, the name of the library to connect to may need to be entered manually.

Update file properties using AI Builder model results

Updates the values stored in library columns for a file analyzed by the model specified by the ModelId.

Update item

Updates an item in a SharePoint list.

Add attachment

Adds a new attachment to the specified list item.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

List Name
table True string

SharePoint list name.

Id
itemId True integer

Id of the list item to attach the file to.

File Name
displayName True string

File name.

File Content
body True binary

Content of the file.

Returns

SharePoint list item attachment

Approve hub site join request

Approve hub site join request. This will return an approval token that can be used to complete the join request using the join hub site action.

Parameters

Name Key Required Type Description
Hub Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Requesting Site Id
joiningSiteId True string

Id of the requesting site.

Returns

Result object of ApproveHubSiteJoin action

Cancel hub site join request

Cancel hub join request. If applicable, you should specify the same Approval Correlation Id as used in the "Set hub site join status to pending" action.

Parameters

Name Key Required Type Description
Requesting Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Approval Correlation Id
approvalCorrelationId string

Approval correlation identifier for this request.

Check if the scheduled version of the item is published [DEPRECATED]

Returns the result in the output variable IsFilePublished.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Library Name
table True string

SharePoint library name.

Item ID
id True integer

Unique identifier of the file.

Scheduled Version
scheduledVersion True string

Version of file that was scheduled for publish.

Returns

Output object of the CheckIfFileIsPublished endpoint on the SPO Connector shim

Check in file

Check in a checked out file in a document library, which makes the version of the document available to others.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Library Name
table True string

SharePoint library name.

Id
id True integer

Id of the list item the file is attached to.

Comments
comment True string

Type comments describing what has changed in this version

Check in type
checkinType True integer

Select the type of version you would like to check in

Check out file

Check out a file in a document library to prevent others from editing the document, and your changes from being visible until the documented is checked in.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Library Name
table True string

SharePoint library name.

Id
id True integer

Id of the list item the file is attached to.

Copy file

Copies a file. Works in a similar way to the "Copy to" command in SharePoint libraries. Returns information about the new file after copy.

Parameters

Name Key Required Type Description
Current Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

File to Copy
sourceFileId True string

File Identifier

Destination Site Address
destinationDataset True string

Example: https://contoso.sharepoint.com/sites/sitename

Destination Folder
destinationFolderPath True string

Destination Folder

If another file is already there
nameConflictBehavior True integer

Pick one of the options available

Returns

The SharePoint version of the BlobMetadataResponse extends the object by adding some additional fields that we want serialized

Copy file (deprecated)

Copies a file to a SharePoint site.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Source File Path
source True string

Path to the source file.

Destination File Path
destination True string

Path to the destination file.

Overwrite Flag
overwrite boolean

Whether or not to overwrite the destination file if it exists.

Returns

Blob metadata

Copy folder

Copies a folder. Works in a similar way to the "Copy to" command in SharePoint libraries. Returns information about the new folder after copy.

Parameters

Name Key Required Type Description
Current Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Folder to Copy
sourceFolderId True string

File Identifier

Destination Site Address
destinationDataset True string

Example: https://contoso.sharepoint.com/sites/sitename

Destination Folder
destinationFolderPath True string

Destination Folder

If another folder is already there
nameConflictBehavior True integer

Pick one of the options available

Returns

The SharePoint version of the BlobMetadataResponse extends the object by adding some additional fields that we want serialized

Create file

Uploads a file to a SharePoint site. Make sure to pick an existing library.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Folder Path
folderPath True string

Must start with an existing library. Add folders if needed.

File Name
name True string

Name of the file.

File Content
body True binary

Content of the file.

Returns

The SharePoint version of the BlobMetadataResponse extends the object by adding some additional fields that we want serialized

Create item

Creates a new item in a SharePoint list.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename

List Name
table True string

SharePoint list name

Item
item True dynamic

Item to create

Limit Columns by View
view string

Avoid column threshold issues by only using columns defined in a view

Returns

The outputs of this operation are dynamic.

Create new document set

Creates a new document set list item.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Library
table True string

SharePoint library name.

Document Set Path
path True string

Example: folder1/folder2/dsName

Content Type Id
contentTypeId True string

Example: 0x0120D520

DynamicProperties
DynamicProperties object

Returns

The outputs of this operation are dynamic.

Create new folder

Creates a new folder or folder path.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

List or Library
table True string

SharePoint list or library name.

Folder Path
path True string

Example: folder1/folder2/folder3

Limit Columns by View
view string

Avoid column threshold issues by only using columns defined in a view.

Returns

The outputs of this operation are dynamic.

Create sharing link for a file or folder.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Library Name
table True string

SharePoint library name.

Item Id
id True integer

Id of the file or folder item.

Link Type
type True string

The type of sharing link to create

Link Scope
scope True string

Choose who your sharing link gives access to. "Anyone" option will only work if your administrator has enabled it.

Link Expiration
expirationDateTime date-time

The date after which the link will expire in yyyy-MM-dd format. Only applicable for anonymous links.

Returns

Internal structure for sharing links

Delete attachment

Deletes the specified attachment.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

List Name
table True string

SharePoint list name.

Id
itemId True integer

Id of the list item the file is attached to.

File Identifier
attachmentId True string

File identifier for the attachment.

Delete file

Deletes the file specified by the file identifier.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

File Identifier
id True string

Select a file.

Delete item

Deletes an item from a SharePoint list.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename

List Name
table True string

SharePoint list name

Id
id True integer

Unique identifier of item to be deleted

Discard check out

If you check out a file and don’t make changes to it, or you make changes that you don’t want to keep, you can simply discard the checkout, rather than saving the file. If your organization tracks versions, a new version is created each time you check a file back into the library. By discarding the checkout, you can avoid making new versions when you haven’t made any changes to the file.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Library Name
table True string

SharePoint library name.

Id
id True integer

Id of the list item the file is attached to.

Extract folder

Extracts an archive file into a SharePoint folder (example: .zip).

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Source File Path
source True string

Path to the source file.

Destination Folder Path
destination True string

Path to the destination folder.

Overwrite Flag
overwrite boolean

Whether or not to overwrite the destination file if it exists.

Returns

Generate document using Microsoft Syntex (preview)

Use this action to create documents based on modern templates from Microsoft Syntex. This preview requires a Syntex license. Pricing is subject to change. For more info see: https://docs.microsoft.com/en-us/microsoft-365/contentunderstanding/content-assembly.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Document Library Name
table True string

SharePoint document library name.

Document Template
template True string

Document template.

Placeholders
item True dynamic

Document placeholder values.

Folder Path
folderPath string

Must start with an existing library.

File Name
fileName string

Document file name.

Returns

The SharePoint version of the BlobMetadataResponse extends the object by adding some additional fields that we want serialized

Get all lists and libraries

Get all lists and libraries.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Returns

Represents a list of tables.

Body
TablesList

Get attachment content

Returns file contents using the file identifier. The contents can be copied somewhere else, or be used as an attachment.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

List Name
table True string

SharePoint list name.

Id
itemId True integer

Id of the list item the file is attached to.

File Identifier
attachmentId True string

File identifier for the attachment.

Returns

The content of the attachment.

Attachment Content
binary

Get attachments

Returns the list of attachments for the specified list item. You can add a "Get attachment content" step and use the "File identifier" property returned by this action to get to the contents of the file.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

List Name
table True string

SharePoint list name.

Id
itemId True string

Id of the list item to get attachments from.

Returns

Get changes for an item or a file (properties only)

Returns information about columns that have changed within a given time window. Note: The list must have Versioning turned on.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

List or Library Name
table True string

SharePoint list or library name.

Id
id True integer

Id of the item you want to fetch changes for.

Since
since True string

Trigger Window Start token or an item version label (ex: 3.0) or an ISO 8601 date (YYYY-MM-DDThh:mmZ).

Until
until string

Trigger Window End token or an item version label (ex: 3.0) or an ISO 8601 date (YYYY-MM-DDThh:mmZ). If blank, defaults to latest version.

Include Minor Versions
includeDrafts boolean

Boolean for whether to consider changes from minor (draft) versions.

Limit Columns by View
view string

Returns only columns defined in a view.

Returns

The outputs of this operation are dynamic.

Get file content

Gets file contents using the file identifier. The contents can be copied somewhere else, or be used as an attachment.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

File Identifier
id True string

Select a file.

Infer Content Type
inferContentType boolean

Infer content-type based on extension.

Returns

The content of the file.

File Content
binary

Get file content using path

Gets file contents using the file path.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

File Path
path True string

Select a file.

Infer Content Type
inferContentType boolean

Infer content-type based on extension.

Returns

The content of the file.

File Content
binary

Get file metadata

Gets information about the file such as size, etag, created date, etc. Uses a file identifier to pick the file. Use "Get file properties" action to get to the values stored in the columns in the library.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

File Identifier
id True string

Select a file.

Returns

The SharePoint version of the BlobMetadataResponse extends the object by adding some additional fields that we want serialized

Get file metadata using path

Gets information about the file such as size, etag, created date, etc. Uses a file path to pick the file. Use "Get file properties" action to get to the values stored in the columns in the library.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

File Path
path True string

Select a file.

Returns

The SharePoint version of the BlobMetadataResponse extends the object by adding some additional fields that we want serialized

Get file properties

Gets the properties saved in the columns in the library for the item specified by the item id. You can add a "Get file content" step and use the "File identifier" property returned by this action to get to the contents of the file. When using this with the On-Premises Data Gateway, the name of the library to connect to may need to be entered manually.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename

Library Name
table True string

SharePoint library name

Id
id True integer

Unique identifier of item to be retrieved

Limit Columns by View
view string

Avoid column threshold issues by only using columns defined in a view

Returns

The outputs of this operation are dynamic.

Get files (properties only)

Gets the properties saved in the columns in the library for all folders and files stored in the library. You can also filter down to the items that match a condition. An "Apply to each" section is usually used to work with the output from this action. When using this with the On-Premises Data Gateway, the name of the library to connect to may need to be entered manually.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename

Library Name
table True string

SharePoint library name

Filter Query
$filter string

An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).

Order By
$orderby string

An ODATA orderBy query for specifying the order of entries.

Top Count
$top integer

Total number of entries to retrieve (default = all).

Limit Entries to Folder
folderPath string

Select a folder, or leave blank for the whole library

Include Nested Items
viewScopeOption string

Return entries contained in sub-folders (default = true)

Limit Columns by View
view string

Avoid column threshold issues by only using columns defined in a view

Returns

The outputs of this operation are dynamic.

Get folder metadata

Gets information about the folder. Uses a file identifier to pick the folder.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

File Identifier
id True string

Select a folder.

Returns

The SharePoint version of the BlobMetadataResponse extends the object by adding some additional fields that we want serialized

Get folder metadata using path

Gets information about the folder. Uses a folder path to pick the folder.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Folder Path
path True string

Select a folder.

Returns

The SharePoint version of the BlobMetadataResponse extends the object by adding some additional fields that we want serialized

Get item

Gets a single item by its id from a SharePoint list.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename

List Name
table True string

SharePoint list name

Id
id True integer

Unique identifier of item to be retrieved

Limit Columns by View
view string

Avoid column threshold issues by only using columns defined in a view

Returns

The outputs of this operation are dynamic.

Get items

Gets items from a SharePoint list.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename

List Name
table True string

SharePoint list name

Filter Query
$filter string

An ODATA filter query to restrict the entries returned (e.g. stringColumn eq 'string' OR numberColumn lt 123).

Order By
$orderby string

An ODATA orderBy query for specifying the order of entries.

Top Count
$top integer

Total number of entries to retrieve (default = all).

Limit Entries to Folder
folderPath string

Select a folder, or leave blank for the whole list

Include Nested Items
viewScopeOption string

Return entries contained in sub-folders (default = true)

Limit Columns by View
view string

Avoid column threshold issues by only using columns defined in a view

Returns

The outputs of this operation are dynamic.

Get list views

Gets views from a SharePoint list.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

List Name
table True string

SharePoint list name.

Returns

List of Tables
array of Table

Get lists

Gets SharePoint lists from a site.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename

Returns

Represents a list of tables.

Body
TablesList

Grant access to an item or a folder

Grant access to an item or a folder in SharePoint to specific people.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

List or Library Name
table True string

SharePoint list or library name.

Id
id True integer

Unique identifier of the item or folder you want to grant access to.

Recipients
recipients True email

A collection of recipients who will receive the sharing invitation

Roles
roleValue True string

Specify a role that is to be granted to the recipients

Message
emailBody string

A plain text formatted message that is included in the sharing invitation

Notify Recipients
sendEmail boolean

Specify whether recipients should receive an email notification message

Join hub site

Join the requested site to the hub site. An Approval Token is required to complete the join successfully if that hub requires approval. If applicable, you should specify the same Approval Correlation Id as used in the "Set hub site join status to pending" action.

Parameters

Name Key Required Type Description
Requesting Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Hub Site Id
hubSiteId True string

Id of the hub site.

Approval Token
approvalToken string

Approval token for this request.

Approval Correlation Id
approvalCorrelationId string

Approval correlation identifier for this request.

List folder

Returns files contained in a SharePoint folder.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

File Identifier
id True string

Unique identifier of the folder.

Returns

List root folder

Returns files in the root SharePoint folder.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Returns

Move file

Moves a file. Works in a similar way to the "Move to" command in SharePoint libraries. Returns information about the new file after move.

Parameters

Name Key Required Type Description
Current Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

File to Move
sourceFileId True string

File Identifier

Destination Site Address
destinationDataset True string

Example: https://contoso.sharepoint.com/sites/sitename

Destination Folder
destinationFolderPath True string

Destination Folder

If another file is already there
nameConflictBehavior True integer

Pick one of the options available

Returns

The SharePoint version of the BlobMetadataResponse extends the object by adding some additional fields that we want serialized

Move folder

Moves a folder. Works in a similar way to the "Move to" command in SharePoint libraries. Returns information about the new folder after move.

Parameters

Name Key Required Type Description
Current Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Folder to Move
sourceFolderId True string

File Identifier

Destination Site Address
destinationDataset True string

Example: https://contoso.sharepoint.com/sites/sitename

Destination Folder
destinationFolderPath True string

Destination Folder

If another folder is already there
nameConflictBehavior True integer

Pick one of the options available

Returns

The SharePoint version of the BlobMetadataResponse extends the object by adding some additional fields that we want serialized

Resolve person

Returns a single matching user value so it can be assigned to a column of type person. If there are no matches, or multiple matches, this action will error out.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

List or Library
table True string

Pick the list or library that the column is in.

Column
entityId True string

Pick the column you want to assign the value to.

Email or name
searchValue True string

Use the email address, or the full name of the user.

Limit Columns by View
view string

Avoid column threshold issues by only using columns defined in a view.

Returns

SharePoint expanded user field

Send an HTTP request to SharePoint

Construct a SharePoint REST API to invoke. Note – This action may execute any SharePoint REST API you have access to. Please proceed with caution.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Method
method True string

Http Method

Uri
uri True string

Example: _api/web/lists/getbytitle('Documents')

Headers
headers object

Enter JSON object of request headers

Body
body string

Enter request content in JSON

Returns

Set content approval status

Sets the content approval status for an item in a list or library that has content approval turned on. You must provide an ETag for pages and files. You can get the ETag using the Get File Metadata action. This action is only available for SharePoint Online and SharePoint 2019.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Library Name
table True string

SharePoint library name.

Id
id True integer

Id of the item you are setting the status of.

Action
approvalAction True string

Pick the approval action.

Comments
comments string

Add the comments from the approver.

ETag
entityTag string

Add an ETag (required for files and pages).

Returns

SetApprovalStatus output

Set hub site join status to pending

Set the requested site's hub join request status to pending. The Approval Correlation Id is an optional parameter that helps SharePoint identify a particular hub join request. The requesting site can only have one pending request at a given time.

Parameters

Name Key Required Type Description
Requesting Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Approval Correlation Id
approvalCorrelationId string

Approval correlation identifier for this request.

Stop sharing an item or a file

Delete all links giving access to an item or a file and remove all people with direct access except for owners.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

List or Library Name
table True string

SharePoint list or library name.

Id
id True integer

Unique identifier of the item or file you want to stop sharing.

Update file

Updates the contents of the file specified by the file identifier.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

File Identifier
id True string

Select a file.

File Content
body True binary

Content of the file.

Returns

Represents blob datasets metadata response

Update file properties

Updates the properties stored in columns in a library for the item specified by the item id. Use "Update file" action to update file contents. When using this with the On-Premises Data Gateway, the name of the library to connect to may need to be entered manually.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename

Library Name
table True string

SharePoint library name

Id
id True integer

Unique identifier of item to be updated

Item
item True dynamic

Item with changed properties

Limit Columns by View
view string

Avoid column threshold issues by only using columns defined in a view

Returns

The outputs of this operation are dynamic.

Update file properties using AI Builder model results

Updates the values stored in library columns for a file analyzed by the model specified by the ModelId.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Library Name
table True string

Library Name.

Id
id True integer

Unique identifier of item to be updated.

ModelId
modelId string

Enter modelId of the Model which is used for prediction

PredictResult
predictResult string

Enter request content in JSON

Returns

The outputs of this operation are dynamic.

Update item

Updates an item in a SharePoint list.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename

List Name
table True string

SharePoint list name

Id
id True integer

Unique identifier of item to be updated

Item
item True dynamic

Item with changed properties

Limit Columns by View
view string

Avoid column threshold issues by only using columns defined in a view

Returns

The outputs of this operation are dynamic.

Triggers

For a selected file

This trigger allows you to start a flow for a selected file. Inputs: Site Address, Library Name. Outputs: Name, Link to Item, ID. (Available only for Power Automate.)

For a selected item

This trigger allows you to start a flow for a selected item in a SharePoint list or library. You can use the columns of the list or library as output parameters. For a file, you can use the "identifier" column to get file content. (Available only for Power Automate.)

When a file is classified by a Microsoft Syntex model

Triggers a flow when Microsoft Syntex changes the classification date of any file in the library. The date changes when a document processing model classifies or extracts information.

When a file is created (properties only)

Triggers when an item is created in a library. Returns only the properties stored in the library columns. You can add a "Get file content" step and use the "File identifier" property returned by this action to get to the contents of the file. When using this with the On-Premises Data Gateway, the name of the library to connect to may need to be entered manually.

When a file is created in a folder (deprecated)

Triggers when a file is created in a SharePoint folder. The trigger does not fire if a file is added/updated in a subfolder. If it is required to trigger on subfolders, multiple triggers should be created.

When a file is created or modified (properties only)

Triggers when an item is created, or modified in a library. Returns only the properties stored in the library columns. You can add a "Get file content" step and use the "File identifier" property returned by this action to get to the contents of the file. When using this with the On-Premises Data Gateway, the name of the library to connect to may need to be entered manually.

When a file is created or modified in a folder (deprecated)

Triggers when a file is created, and also each time it is modified in a SharePoint folder. The trigger does not fire if a file is added/updated in a subfolder. If it is required to trigger on subfolders, multiple triggers should be created.

When a file is deleted

Triggers when a file is deleted in a library. You can optionally specify a folder to watch as well. When a folder is deleted, the trigger will fire only once for the deleted folder. This can only be used by site collection admins of the site where the list is located.

When a site has requested to join a hub site

Triggers a flow upon hub site join approval. (Available only for Power Automate.)

When an item is created

Triggers when an item is created.

When an item is created or modified

Triggers when an item is created, and also each time it is modified.

When an item is deleted

Triggers when an item is deleted in a list. This can only be used by site collection admins of the site where the list is located.

When an item or a file is modified

Triggers when an item is modified (but not when it is created).

For a selected file

This trigger allows you to start a flow for a selected file. Inputs: Site Address, Library Name. Outputs: Name, Link to Item, ID. (Available only for Power Automate.)

Parameters

Name Key Required Type Description
operationId
operationId True string
host
host object
parameters
parameters True object
schema
schema True object
headersSchema
headersSchema object

Returns

Name Path Type Description
rows
body.rows array of object
ID
body.rows.ID integer

File Identifier

itemUrl
body.rows.itemUrl string

File Url

fileName
body.rows.fileName string

File Name

User id
headers.x-ms-user-id-encoded guid

The unique identifier of the user who triggered the flow in AAD.

User email
headers.x-ms-user-email-encoded byte

The email address of the user who triggered the flow.

User name
headers.x-ms-user-name-encoded byte

The display name of the user who triggered the flow.

Timestamp
headers.x-ms-user-timestamp string

The time the flow was triggered.

For a selected item

This trigger allows you to start a flow for a selected item in a SharePoint list or library. You can use the columns of the list or library as output parameters. For a file, you can use the "identifier" column to get file content. (Available only for Power Automate.)

Parameters

Name Key Required Type Description
operationId
operationId True string
host
host object
parameters
parameters True object
schema
schema True object
headersSchema
headersSchema object

Returns

Name Path Type Description
rows
body.rows array of object
ID
body.rows.ID integer

File Identifier

itemUrl
body.rows.itemUrl string

File Url

fileName
body.rows.fileName string

File Name

User id
headers.x-ms-user-id-encoded guid

The unique identifier of the user who triggered the flow in AAD.

User email
headers.x-ms-user-email-encoded byte

The email address of the user who triggered the flow.

User name
headers.x-ms-user-name-encoded byte

The display name of the user who triggered the flow.

Timestamp
headers.x-ms-user-timestamp string

The time the flow was triggered.

When a file is classified by a Microsoft Syntex model

Triggers a flow when Microsoft Syntex changes the classification date of any file in the library. The date changes when a document processing model classifies or extracts information.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename

Library Name
table True string

SharePoint library name

Folder
folderPath string

Select a folder, or leave blank for the whole library

Limit Columns by View
view string

Avoid column threshold issues by only using columns defined in a view

Returns

The outputs of this operation are dynamic.

When a file is created (properties only)

Triggers when an item is created in a library. Returns only the properties stored in the library columns. You can add a "Get file content" step and use the "File identifier" property returned by this action to get to the contents of the file. When using this with the On-Premises Data Gateway, the name of the library to connect to may need to be entered manually.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename

Library Name
table True string

SharePoint library name

Folder
folderPath string

Select a folder, or leave blank for the whole library

Limit Columns by View
view string

Avoid column threshold issues by only using columns defined in a view

Returns

The outputs of this operation are dynamic.

When a file is created in a folder (deprecated)

Triggers when a file is created in a SharePoint folder. The trigger does not fire if a file is added/updated in a subfolder. If it is required to trigger on subfolders, multiple triggers should be created.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Folder Id
folderId True string

Select a folder.

Infer Content Type
inferContentType boolean

Infer content-type based on extension.

Returns

The content of the file.

File Content
binary

When a file is created or modified (properties only)

Triggers when an item is created, or modified in a library. Returns only the properties stored in the library columns. You can add a "Get file content" step and use the "File identifier" property returned by this action to get to the contents of the file. When using this with the On-Premises Data Gateway, the name of the library to connect to may need to be entered manually.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename

Library Name
table True string

SharePoint library name

Folder
folderPath string

Select a folder, or leave blank for the whole library

Limit Columns by View
view string

Avoid column threshold issues by only using columns defined in a view

Returns

The outputs of this operation are dynamic.

When a file is created or modified in a folder (deprecated)

Triggers when a file is created, and also each time it is modified in a SharePoint folder. The trigger does not fire if a file is added/updated in a subfolder. If it is required to trigger on subfolders, multiple triggers should be created.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename.

Folder Id
folderId True string

Select a folder.

Infer Content Type
inferContentType boolean

Infer content-type based on extension.

Returns

The content of the file.

File Content
binary

When a file is deleted

Triggers when a file is deleted in a library. You can optionally specify a folder to watch as well. When a folder is deleted, the trigger will fire only once for the deleted folder. This can only be used by site collection admins of the site where the list is located.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename

Library Name
table True string

SharePoint library name

Folder
folderPath string

Select a folder, or leave blank for the whole library

Returns

List of Deleted items

When a site has requested to join a hub site

Triggers a flow upon hub site join approval. (Available only for Power Automate.)

Parameters

Name Key Required Type Description
operationId
operationId True string
host
host object
parameters
parameters True object
schema
schema True object
headersSchema
headersSchema object

Returns

Name Path Type Description
rows
body.rows array of object
RequestingSiteUrl
body.rows.RequestingSiteUrl string

Requesting Site Url

RequestingSiteId
body.rows.RequestingSiteId string

Requesting Site Id

RequestingSiteTitle
body.rows.RequestingSiteTitle string

Requesting Site Title

ApprovalCorrelationId
body.rows.ApprovalCorrelationId string

Approval Correlation Id

User id
headers.x-ms-user-id-encoded guid

The unique identifier of the user who triggered the flow in AAD.

User email
headers.x-ms-user-email-encoded byte

The email address of the user who triggered the flow.

User name
headers.x-ms-user-name-encoded byte

The display name of the user who triggered the flow.

Timestamp
headers.x-ms-user-timestamp string

The time the flow was triggered.

When an item is created

Triggers when an item is created.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename

List Name
table True string

SharePoint list name

Limit Columns by View
view string

Avoid column threshold issues by only using columns defined in a view

Returns

The outputs of this operation are dynamic.

When an item is created or modified

Triggers when an item is created, and also each time it is modified.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename

List Name
table True string

SharePoint list name

Limit Columns by View
view string

Avoid column threshold issues by only using columns defined in a view

Returns

The outputs of this operation are dynamic.

When an item is deleted

Triggers when an item is deleted in a list. This can only be used by site collection admins of the site where the list is located.

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename

List Name
table True string

SharePoint list name

Returns

List of Deleted items

When an item or a file is modified

Triggers when an item is modified (but not when it is created).

Parameters

Name Key Required Type Description
Site Address
dataset True string

Example: https://contoso.sharepoint.com/sites/sitename

List or Library Name
table True string

SharePoint list name

Folder
folderPath string

Select a folder, or leave blank for the whole library

Limit Columns by View
view string

Avoid column threshold issues by only using columns defined in a view

Returns

The outputs of this operation are dynamic.

Definitions

Internal structure for sharing links

Name Path Type Description
Sharing Link
webUrl string

A link to the item

SharingLinkPermission

Internal structure for sharing links

Name Path Type Description
link
link SharingLink

Internal structure for sharing links

Table

Represents a table.

Name Path Type Description
Name
Name string

The name of the table. The name is used at runtime.

DisplayName
DisplayName string

The display name of the table.

DynamicProperties
DynamicProperties object

Additional table properties provided by the connector to the clients.

SPBlobMetadataResponse

The SharePoint version of the BlobMetadataResponse extends the object by adding some additional fields that we want serialized

Name Path Type Description
ItemId
ItemId integer

The value that can be used to Get or Update file properties in libraries.

Id
Id string

The unique id of the file or folder.

Name
Name string

The name of the file or folder.

DisplayName
DisplayName string

The display name of the file or folder.

Path
Path string

The path of the file or folder.

LastModified
LastModified date-time

The date and time the file or folder was last modified.

Size
Size integer

The size of the file or folder.

MediaType
MediaType string

The media type of the file or folder.

IsFolder
IsFolder boolean

A boolean value (true, false) to indicate whether or not the blob is a folder.

ETag
ETag string

The etag of the file or folder.

FileLocator
FileLocator string

The filelocator of the file or folder.

TablesList

Represents a list of tables.

Name Path Type Description
value
value array of Table

List of Tables

BlobMetadataResponse

Represents blob datasets metadata response

Name Path Type Description
Id
Id string

The unique id of the file or folder.

Name
Name string

The name of the file or folder.

DisplayName
DisplayName string

The display name of the file or folder.

Path
Path string

The path of the file or folder.

LastModified
LastModified date-time

The date and time the file or folder was last modified.

Size
Size integer

The size of the file or folder.

MediaType
MediaType string

The media type of the file or folder.

IsFolder
IsFolder boolean

A boolean value (true, false) to indicate whether or not the blob is a folder.

ETag
ETag string

The etag of the file or folder.

FileLocator
FileLocator string

The filelocator of the file or folder.

BlobMetadata

Blob metadata

Name Path Type Description
Id
Id string

The unique id of the file or folder.

Name
Name string

The name of the file or folder.

DisplayName
DisplayName string

The display name of the file or folder.

Path
Path string

The path of the file or folder.

LastModified
LastModified date-time

The date and time the file or folder was last modified.

Size
Size integer

The size of the file or folder.

MediaType
MediaType string

The media type of the file or folder.

IsFolder
IsFolder boolean

A boolean value (true, false) to indicate whether or not the blob is a folder.

ETag
ETag string

The etag of the file or folder.

FileLocator
FileLocator string

The filelocator of the file or folder.

SPListExpandedUser

SharePoint expanded user field

Name Path Type Description
Claims
Claims string

user claims

DisplayName
DisplayName string

user title

Email
Email string

user email

Picture
Picture string

user picture

Department
Department string

user department

JobTitle
JobTitle string

user job title

@odata.type
@odata.type string

PublishedResult

Output object of the CheckIfFileIsPublished endpoint on the SPO Connector shim

Name Path Type Description
IsFilePublished
IsFilePublished boolean

A boolean value (true, false) to indicate whether the scheduled version of the file has been published

SetApprovalStatusOutput

SetApprovalStatus output

Name Path Type Description
ETag
ETag string

ETag of the item after the approval status was set

ApprovalLink
ApprovalLink string

A link to the item that needs approval

PublishStartDate
PublishStartDate string

Date time at which the item will be Published

ContentApprovalStatus
ContentApprovalStatus string

The content approval status of the list item

ScheduledVersion
ScheduledVersion string

The version of the item that has been scheduled

SPListItemAttachment

SharePoint list item attachment

Name Path Type Description
Id
Id string

File identifier

AbsoluteUri
AbsoluteUri string

Link to attachment

DisplayName
DisplayName string

Name

ApproveHubSiteJoinResponse

Result object of ApproveHubSiteJoin action

Name Path Type Description
ApprovalToken
ApprovalToken string

Approval Token

DeletedItemList

List of Deleted items

Name Path Type Description
value
value array of DeletedItem

List of Deleted Items

DeletedItem

An item deleted from a SharePoint list or library

Name Path Type Description
ID
ID integer

List item id

Name
Name string

File name of the item in document libraries, display name of the item in lists

Filename with extension
FileNameWithExtension string

File name with extension of the item in document libraries, same as Name of the item in lists

Deleted by
DeletedByUserName string

The name of the user who deleted this item

Time deleted
TimeDeleted date-time

When this item was deleted

Is folder
IsFolder boolean

A true/false value to indicate if the item is a folder

binary

This is the basic data type 'binary'.