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.

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Top Solution Authors
Top Kudoed Authors
Users online (53,457)