Answered

Get SharePoint List Item Previous Version Information

(0) Share

Report

Posted on by landonjochim

256

I am trying to perform a Send HTTP Request to retrieve the previous version of a SharePoint list item. I realize that you can do _api/web/lists/GetByTitle('ListName')/items(ID)/Versions to retreive all versions and their information. But I only want to receive the specific version I am interested in.

Below is what I am currently doing, and the response I get back.

After running the flow..

Any support would be very much appreciated.

Thanks!

Categories:

Building flows

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

MarvinBangert 1,924 Most Valuable Professional on at

Like (7)

Report

Hey @landonjochim
you are on the correct way, but the versionID is not used with 1,2,3,4... they have different counting like:
1 = 512
2 = 1024
3 = 1536
4 = 2048
5 = 2560
6 = 3072
7 = 3584
8 = 4096
9 = 4608
10 = 5120
You can also just leave out the () behind the versions to receive all versions then you can lookup what ID are used in the field "VersionId". When you put in these VersionId in you versions() you will receive only this version of your item.

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
landonjochim 256 on at

Like (0)

Report

@MarvinBangert Can it be assumed that whatever the Version Number is * 512 will give me the VersionID that it will understand?

Was this reply helpful? Yes No
MarvinBangert 1,924 Most Valuable Professional on at

Like (0)

Report

@landonjochim
I did not tested it on every version, but the schema looks like that, yes.

Best regards
Marvin

If you like this post, give a Thumbs up. If it solved your request, Mark it as a Solution to enable other users to find it.

Was this reply helpful? Yes No
Mahmoud1993 4 on at

Like (1)

Report

you can use this expression to calculate previous versionID: (VersionNumber*512)-512
sub(mul(int(triggerOutputs()?['body/{VersionNumber}']),512),512)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Lifesaver, man - works like a charm, appreciated! I initialize and default a "PreviousVersion" variable to your formula by pasting it directly into the Expressions Builder.

Was able to run the "Send HTTP Request to SharePoint" using
_api/web/lists/GetByTitle('My List')/items(ID)/Versions(PreviousVersion)?$select=Status

Because I only cared about getting the "Status" value from the previous version.

I add a Header of Accept and application/json;odata=nometadata as the key/value pair per:
Working with the SharePoint Send HTTP Request flow action in Power Automate | Microsoft Learn

Then I set a variable of "OldStatus" right after it to
body('Send_an_HTTP_request_to_SharePoint' )['Status']
in the dynamic expression. Works great!

Was this reply helpful? Yes No