SharePoint version history in PowerApps

[pkvaranasi]

Hi,

Is there anyway to retrieve the version history of each list item in a SharePoint List can be shown in the PowerApps app by directly binding to it?

I don't see the Version History details like Version Info, but can see Modified & Modified By.

I would like to retrieve the version numbers of each version and the text.

[v-micsh-msft]

Hi @pkvaranasi,

Do you mean the Append comments field?

Currently it is only avaialbale to display the latest comments under PowerApps, the version history is not supported.

There is a similar idea submitted on this already:

Append comments Field

Please vote it up if it also meets your requirements, or you may consider submit your own.

A workaround is 

1. export version history of SharePoint List Items to Microsoft Excel,

2. Connect Excel Data under PowerApps, make sure the data imported in Excel has been formatted into table

Regards,

Michael

[Narula_Srinivas]

@pkvaranasi : Even I had same requirement. This can be acheived by creating azure function and consuming using data connector.

Once I complete it, will share with you all.

Happy Coding!!

[Anonymous]

Hi Narula,

Did you ever get the data connector working for the SharePoint list? I thought about doing a custom implmentation in SQL but version history in SharePoint is alot easier to setup and manage for smaller projects.

Regards,

Brandon

[MikeLockwood · Accepted solution]

I found a round about way of doing this using Flow.  You have to know the ID of the item of the item you want versions from and then in flow you can use the "Send an HTTP request to SharePoint".  For the URI you need to use "_api/web/lists/GetByTitle([ListName])/items[ID]/Version.  This will get the list of data.  Then use the HTTP Response object to send it back to PowerApps.  You have to ensure you format the response correct.  But so far I am seeing that this works.

[pkvaranasi]

Great. Thanks.

[BradGroux]

Thanks for this workaround! Saved me a lot of searching and frustration!

[gmaasz]

an you show an example of how to enter the list name with actual text please. Not just the placeholder. 

[MikeLockwood]

I think this is what you are asking for.

The SharePointList name is Work Orders and the ID of the record I want to look at is 22.  With that I mind then the URL would look like the following.

_api/web/lists/GetByTitle('Work Orders')/items(22)/Version

[Macjan]

Can you please elaborate on that solution? It's my first time using flow and I can't find beginner-friendly guide on pulling list version data from SharePoint using HTTP request.

So far I have this:

- Address is in and can confirm it works as I had used it numerous times in other apps;

- Method: GET;

- URI: concat('_api/web/lists/GetByTitle([My_List])/items[', triggerBody()['Record_ID'] ,']/Version')

- Header: "Accept: application/json; odata=": "nometadata"

- Text: ???

What do I need to write in Text to get the version list of a record? Does the header need additional values?