Unanswered

How to get the lasts 2 versions and what columns has been changed

(0) Share

Report

Posted on by heyjay

Hello everyone,

I need help with my scenario, I ran a flow to update all my 3000 items in the list which caused the issue that I am having right now.

I need to undo the last flow run that I made, I have to get all the items in my list to be reverted back to the previous versions before I mistakenly ran the flow I made.

I need help on how to get the last 2 versions, the latest version is the one where I made the mistake, and the previous version is the correct version where all the values of the status column are correct. I need to get the columns where the values where changed because I am not sure which other columns has to be reverted back to its previous values aside from the status column. Is this possible?

If I can get the column names its new and old values, then revert back to its old values it would be great. Right now, my last option is to do the version history in every item manually. Please help.

Categories:

General topics

I have the same question (0)

All responses (10)

Answers (0)

SanmeshG 1,947 Moderator on at

Like (0)

Report

Hi @heyjay ,

You can use the Send an HTTP Request to SharePoint action in Power Automate to get the versions of your SP List.
Also you can use the action Get changes for an item or a file (properties only) to know the changes in the column.

Please checkout the below thread for a detailed post.
https://www.catapultsystems.com/blogs/get-previous-versions-of-sharepoint-list-items-in-flow/

If this helps , please give this a thumbs up and accept it as a solution.

Thanks,

Was this reply helpful? Yes No
heyjay 42 on at

Like (0)

Report

Hi @SanmeshG ,

Appreciate your response, however in the given post, the flow starts with "When an Item is created or modified", I can't have that as a trigger since the change has already been made and I need to restore the changes back to the previous version. Is that possible?

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report

Hi @heyjay ,

Yes that should be possible. For each Item in SP List , you have to calculate the previous version of the item and update the values.

So your flow can be a manual flow.

1. Manual Trigger.
2. Get Items
3. Send an HTTP Action to get Version History inside an apply to each loop
4. Get Results Array and check if the length is greater than 1(using Parse JSON), If yes
4.1. Get the most recent version and subtract 1
4.2 Update the item in the SP List using the columns from Filter array action(see screenshots)

I am not sure if there is any other shortcut method.

If this helps , please give this a thumbs up and accept this as a solution.

Thanks,

Was this reply helpful? Yes No
heyjay 42 on at

Like (1)

Report

Hi @SanmeshG ,

Appreciate your help on this, I will try your solution and will get back to you.

Was this reply helpful? Yes No
heyjay 42 on at

Like (0)

Report

Hello @SanmeshG ,

I am stuck with Parse JSON action, I tried using the Results Array in the Content part of Parse JSON and the Schema is from the Results Array Output, am I doing something wrong?

Was this reply helpful? Yes No
heyjay 42 on at

Like (0)

Report

Hi @SanmeshG ,

Can you please expand the Results Array, Parse JSON, Length of Results Array so I can see exactly what is the syntax you used, and also are those "Compose" action? Sorry, I'm new to this.

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report
Hi @heyjay ,

You can do it without the Parse JSON action as well.

Please add a compose action and use the below expression.
outputs('Results_Array')[0]?['versionLabel']
Now based on this you can have a condition.

The output of the above Compose action can be used in condition to decide whether the item should be restored or not. It it returns 1.0 then you need not update else you update.

Hope this solves your issue.

Thanks,
Sanmesh

Was this reply helpful? Yes No
heyjay 42 on at

Like (0)

Report
Hi @SanmeshG ,

I'm sorry but I am confused now, I replaced the old Parsed JSON action with the one you mentioned, I created a compose action with this expression:
outputs('Results_Array')[0]?['versionLabel']
and now, I get an error with the Get Latest Version compose action.

Was this reply helpful? Yes No
SanmeshG 1,947 Moderator on at

Like (0)

Report

Hi @heyjay ,

Can you share the screenshots of your flow , you have to remove the Parse JSON action completely. And also , the Length of Results Array(see Screenshot 2). In the condition you will use the above expression and match it with 1.0 with condition set to not equal to.

And it should work.

Was this reply helpful? Yes No
heyjay 42 on at

Like (0)

Report

Hi @SanmeshG ,

Here you go:

This was the original flow I made.
Then I changed it according to your instructions:

Was this reply helpful? Yes No