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:

This reference article describes the operations and other information about the SharePoint connector available in the previously listed services and products.

General known issues and limitations

• This connector supports list item attachment sizes up to 90 MB.
• "Deprecated" triggers and actions are no longer actively maintained. While these operations still exist in this connector, you're strongly advised to not use them in any new solutions or apps.
• Conditional access policies, such as multi-factor authentication or device compliance policies, might block access to data available through this connector. For more information, see Microsoft Entra ID Conditional Access.
• Guest user accounts can't view or retrieve drop-down list information in connector operations.
• If you get an incomplete data set, or if you can't get accurate results from a SharePoint list, this problem might by caused by delegation limits. For more information, see SharePoint delegation improvements.
• This connector doesn't support setting up sensitivity labels on a SharePoint file.
• Term set label updates don't automatically appear in a connected flow or app. To work around this problem, directly edit the affected list item to force refresh the term set label.
• If the extraction process encounters special characters, the action named Extract folder might lead to character distortion. To avoid this problem, use a modern zip archive tool or library that adheres to the standard zip specification. This guidance means that the action should use the UTF-8 encoding process and set the language encoding header flag when the action constructs the zip file. For an example library, see the .NET Zip Archive SDK). This scenario isn't a limitation in the connector's ability to support special character zips in the operation, but rather an issue with the archive tool that leads to this problem.

Logic Apps

• This connector supports file sizes up to 100 MB.
• Uploads or downloads for larger files might fail due to buffer size limits. For larger files, consider other approaches such as Microsoft Graph API calls or intermediate storage.

Power Automate

• Flows for lists are supported only in generic lists and generic document libraries. Custom list and library templates are currently unsupported, including but not limited to lists such as Announcements, Contacts, Events, and Tasks.
• If you use the name for list or library as a dynamic value in the List Name parameter, and the name has a period anywhere, for example, MySharePoint.List, the name causes an error. To resolve this error, select the list from the dropdown menu in Power Automate. If you must use the name as a dynamic value, in the List Name parameter, enter the list's ID instead.
• For flows that use the SharePoint trigger named For a selected file or For a selected item, the SharePoint Automate menu lists only the flows in the default environment.
• The Power Automate portal doesn't list specific built-in SharePoint flows, such as Request sign-off, which are also uneditable.
• For a flow with a SharePoint trigger, you can't undo the gesture to enable or disable the trigger's concurrency control. If you try, you get the "CannotDisableTriggerConcurrency" error. To work around this problem, export the flow and edit the JSON file to remove the "concurrency control" element. This action disables the concurrency option when you import the flow.

For more information about the connector in Power Automate, see:

• Build workflows with Power Automate and SharePoint
• Send an email when a new item is created in a SharePoint list
• Microsoft SharePoint Connector in Power Automate

Power Apps

• Custom forms for lists are supported only in generic lists and generic document libraries. Custom list and library templates are currently unsupported, including but not limited to lists such as Announcements, Contacts, Events, and Tasks.
• Custom forms for document libraries support only editing custom metadata. Editing or managing files is unsupported.
• You can't move custom forms after creation to a different list or environment. However, you can set the environment where Power Apps saves new custom forms.
• If the Customize forms option isn't available or doesn't correctly work for your list, the list might contain data types that Power Apps doesn't support.

SharePoint image column limitations in Power Apps

• This connector supports image file sizes up to 90 MB for uploads to a list through Power Apps.
• This connector supports only the listed image formats.
• SharePoint image types might show Full, Large, Medium, and Small modifiers, for example, ThisItem.'Item Photo'.Small. Images with Small, Medium, and Large sizes are created on demand and temporarily cached. An image cached for too long is removed and regenerated on demand.
• Power Apps generally refreshes image metadata every 30 seconds. If you create an app and want to immediately refresh the images, on the data source, select the ellipses button (...) to refresh the data.
• Images stored in a collection won't correctly render. Try directly accessing them by using 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 might 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.

Data type mappings in Power Apps

For more information, see Data type mappings.

Functions and operations in Power Apps delegable to SharePoint

For more information, see Delegable functions and operations for SharePoint.

Delegation notes

• You can delegate expressions joined by And or Or to SharePoint. You can't delegate expressions joined by Not.

• SharePoint supports delegating complex types by deferring the delegation decision to the subfield involved. Check the subfield type on the complex type and then check the table in Delegable functions and operations for SharePoint for delegation capabilities. For the Person data type, you can delegate only Email and DisplayName.

• The SharePoint ID field for a table is a number field in Power Apps. However, SharePoint supports only the equals operator (=) for delegation on an ID field.

• You can't delegate a formula such as Filter(..., IsBlank(CustomerId)) to SharePoint. However, this formula is semantically close to Filter(..., CustomerId = Blank()), which you can delegate to SharePoint. These formulas aren't equivalent because the second formula doesn't treat the empty string ("") as empty. However, the second formula might work for your purposes. On SharePoint, this approach works for the equals operator (=) but not for the not equals operator (<>).

• You can't delegate SharePoint system fields, including the following:

  • ContentType
  • FilenameWithExtension
  • FullPath
  • ​​​​​​Identifier
  • IsCheckedOut
  • IsFolder
  • Link​
  • Name
  • Path
  • ModerationComment
  • ModerationStatus
  • Thumbnail
  • TriggerWindowStartToken
  • TriggerWindowEndToken
  • VersionNumber

General Limits

Creating a connection

The connector supports the following authentication types:

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.

Throttling Limits

Actions

Add attachment

Agreements Solution - Generate document within Agreements Solution workspace

Approve hub site join request

Cancel hub site join request

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

Check in file

Check out file