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.
- 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 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 | 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 |
Nota
SharePoint types that map to Power Apps as complex often have subfields that map to basic types such as text and number.
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 |
- 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
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 |
The connector supports the following authentication types:
Default | Parameters for creating connection. | All regions | Not shareable |
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 |
Name | Calls | Renewal Period |
---|---|---|
API calls per connection | 600 | 60 seconds |
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 Share |
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. |
Adds a new attachment to the specified list item.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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
- Body
- SPListItemAttachment
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 | |
Requesting Site Id
|
joiningSiteId | True | string |
Id of the requesting site. |
Returns
Result object of ApproveHubSiteJoin action
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 | |
Approval Correlation Id
|
approvalCorrelationId | string |
Approval correlation identifier for this request. |
Returns the result in the output variable IsFilePublished.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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
- Body
- PublishedResult
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 | |
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 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 | |
Library Name
|
table | True | string |
SharePoint library name. |
Id
|
id | True | integer |
Id of the list item the file is attached to. |
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 | |
File to Copy
|
sourceFileId | True | string |
File Identifier |
Destination Site Address
|
destinationDataset | True | string | |
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
Copies a file to a SharePoint site.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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
- Body
- BlobMetadata
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 | |
Folder to Copy
|
sourceFolderId | True | string |
File Identifier |
Destination Site Address
|
destinationDataset | True | string | |
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
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 | |
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
Creates a new item in a SharePoint list.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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
Creates a new document set list item.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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
Creates a new folder or folder path.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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
Create sharing link for a file or folder.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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
Deletes the specified attachment.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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. |
Deletes the file specified by the file identifier.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
File Identifier
|
id | True | string |
Select a file. |
Deletes an item from a SharePoint list.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
List Name
|
table | True | string |
SharePoint list name |
Id
|
id | True | integer |
Unique identifier of item to be deleted |
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 | |
Library Name
|
table | True | string |
SharePoint library name. |
Id
|
id | True | integer |
Id of the list item the file is attached to. |
Extracts an archive file into a SharePoint folder (example: .zip).
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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
- response
- array of BlobMetadata
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 | |
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. |
|
View (no effect)
|
view | string |
This parameter does nothing. Please do not use. |
Returns
The SharePoint version of the BlobMetadataResponse extends the object by adding some additional fields that we want serialized
Get all lists and libraries.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string |
Returns
Represents a list of tables.
- Body
- TablesList
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 | |
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
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 | |
List Name
|
table | True | string |
SharePoint list name. |
Id
|
itemId | True | string |
Id of the list item to get attachments from. |
Returns
- response
- array of SPListItemAttachment
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 | |
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
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 | |
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
Gets file contents using the file path.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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
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 | |
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
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 | |
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
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 | |
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
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 | |
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
Gets information about the folder. Uses a file identifier to pick the folder.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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
Gets information about the folder. Uses a folder path to pick the folder.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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
Gets a single item by its id from a SharePoint list.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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
Gets items from a SharePoint list.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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
Gets views from a SharePoint list.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
List Name
|
table | True | string |
SharePoint list name. |
Returns
- List of Tables
- array of Table
Gets SharePoint lists from a site.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string |
Returns
Represents a list of tables.
- Body
- TablesList
Grant access to an item or a folder in SharePoint to specific people.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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 |
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 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 | |
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. |
Returns files contained in a SharePoint folder.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
File Identifier
|
id | True | string |
Unique identifier of the folder. |
Returns
- response
- array of BlobMetadata
Returns files in the root SharePoint folder.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string |
Returns
- response
- array of BlobMetadata
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 | |
File to Move
|
sourceFileId | True | string |
File Identifier |
Destination Site Address
|
destinationDataset | True | string | |
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
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 | |
Folder to Move
|
sourceFolderId | True | string |
File Identifier |
Destination Site Address
|
destinationDataset | True | string | |
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
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 | |
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
- Body
- SPListExpandedUser
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 | |
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
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 | |
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 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 | |
Approval Correlation Id
|
approvalCorrelationId | string |
Approval correlation identifier for this request. |
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 | |
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. |
Updates the contents of the file specified by the file identifier.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
File Identifier
|
id | True | string |
Select a file. |
File Content
|
body | True | binary |
Content of the file. |
Returns
Represents blob datasets metadata response
- Body
- BlobMetadataResponse
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 | |
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
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 | |
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
Updates an item in a SharePoint list.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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
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). |
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. |
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. |
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 | |
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
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 | |
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
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 | |
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
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 | |
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
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 | |
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
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 | |
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
- Body
- DeletedItemList
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. |
Triggers when an item is created.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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
Triggers when an item is created, and also each time it is modified.
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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
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 | |
List Name
|
table | True | string |
SharePoint list name |
Returns
List of Deleted items
- Body
- DeletedItemList
Triggers when an item is modified (but not when it is created).
Parameters
Name | Key | Required | Type | Description |
---|---|---|---|---|
Site Address
|
dataset | True | string | |
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
Result object of ApproveHubSiteJoin action
Name | Path | Type | Description |
---|---|---|---|
ApprovalToken
|
ApprovalToken | string |
Approval Token |
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. |
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. |
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 |
List of Deleted items
Name | Path | Type | Description |
---|---|---|---|
value
|
value | array of DeletedItem |
List of Deleted Items |
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 |
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 |
Internal structure for sharing links
Name | Path | Type | Description |
---|---|---|---|
Sharing Link
|
webUrl | string |
A link to the item |
Internal structure for sharing links
Name | Path | Type | Description |
---|---|---|---|
link
|
link | SharingLink |
Internal structure for sharing links |
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. |
SharePoint expanded user field
Name | Path | Type | Description |
---|---|---|---|
Claims
|
Claims | string |
user claims |
DisplayName
|
DisplayName | string |
user title |
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 |
SharePoint list item attachment
Name | Path | Type | Description |
---|---|---|---|
Id
|
Id | string |
File identifier |
AbsoluteUri
|
AbsoluteUri | string |
Link to attachment |
DisplayName
|
DisplayName | string |
Name |
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. |
Represents a list of tables.
Name | Path | Type | Description |
---|---|---|---|
value
|
value | array of Table |
List of Tables |
This is the basic data type 'binary'.