cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pkvaranasi
Regular Visitor

SharePoint version history in PowerApps

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.

1 ACCEPTED SOLUTION

Accepted Solutions
MikeLockwood
Advocate IV
Advocate IV

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.

Thanks,
Mike L.

View solution in original post

22 REPLIES 22
v-micsh-msft
Community Support
Community Support

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

Community Support Team _ Michael Shao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Narula_Srinivas
Advocate II
Advocate II

@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
Not applicable

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
Advocate IV
Advocate IV

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.

Thanks,
Mike L.

Great. Thanks.

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

Anonymous
Not applicable

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

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

Thanks,
Mike L.

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?

 

Helpful resources

Announcements
Power Platform Call June 2022 768x460.png

Power Platform Community Call

Join us for the next call on August 17, 2022 at 8am PDT.

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Users online (1,816)