Power Platform Community Forum Thread Details

Connector for SharePoint Item Version History

Goal: Display an Item's version history in a PowerApps Screen. (Show data in a gallery)

I assume a custom connector would be the best way to obtain the data to display. Feel free to offer an alternative.

The REST call to get the SharePoint Item Version History is:

GET /sites/{site-id}/lists/{list-id}/items/{item-id}/versions/{version-id}?expand=field

https://learn.microsoft.com/en-us/onedrive/developer/rest-api/api/listitemversion_get?view=odsp-graph-online

I tried making a custom connector in Power Automate, but the wizard is unintuitive and I'm not familiar with Swagger to know what goes where.

How does one construct a custom connector to retrieve this data?

For bonus points, how would one supply parameters to the Custom Connector, like the SiteID, ListID, and ItemID, such that only one custom connector could be used dynamically?

Categories:

Authentication

Understand the API Call - GET /sites/{site-id}/lists/{list-id}/items/{item-id}/versions?expand=fields

Set Up a Custom Connector in Power Automate

Navigate to Data > Custom Connectors and click + New Custom Connector.

Name your connector (e.g., SPVersionHistory).

Add an Icon and description. Host: graph.microsoft.com Base URL: /v1.0

Choose OAuth 2.0. Set the Identity Provider to Azure Active Directory. Add the following values: Client ID: From your Azure App Registration. Client Secret: From your Azure App Registration. Resource URL: https://graph.microsoft.com Redirect URL: Copy the value provided in Power Automate.

Click + New Action to define the API operation. Fill in: Summary: Get Version History Description: Retrieve the version history of a SharePoint list item Operation ID: GetVersionHistory Request: Verb: GET URL: /sites/{siteId}/lists/{listId}/items/{itemId}/versions Add the Query Parameter: expand: Value is fields. Add Path Parameters: siteId: String listId: String itemId: String

You custom connector will be created and ready for testing.

Quick Links

Leaderboard