cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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
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
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.
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

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

Great. Thanks.

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

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
New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users

Congratulations!

We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (51,776)