Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Power Automate - Building Flows
Answered

Approval flow on SharePoint list modifications

Like (0) ShareShare
ReportReport
Posted on 27 May 2020 13:50:32 by

Hi everyone,

 

I'm struggling with specific logic in building an approval flow in Power Automate:

 

Requirement

We have a SharePoint list in which end-users are meant to make modifications, though an approval flow is required to approve any list modification.

 

Problem in Power Automate

I have built up the approval workflow, works fine when the list modification is approved. The logic I am struggling with is the following (trying to explain step-by-step below):

 

1) As soon as a modification is made in the SharePoint list (despite it having an approval flow in Power Automate), the modification is made effective on the list. This is fine if the value change is ultimately approved, not so when rejected. If the requested modification is rejected, the value on the list should be reverted back to the pre-approval value.

 

2) Therefore we have a secondary (hidden) SharePoint list holding the 'master' version of the SharePoint list, which is only to be updated when a list modification is approved

 

3) If the approval is ultimately rejected, I am trying to apply the following logic:

- Get all values from a secondary SharePoint list (holding same list data, including all approved list changes)

- Match the item that was under approval from the primary SharePoint to the secondary SharePoint list

- Revert the item for which the approval was rejected back to its original value(s) (as the requested modification is rejected, thus the value changes made should be reverted, and no longer effective)

 

My question

Am I missing something here, or would I need to work with a secondary SharePoint list to make the above logic work? Hoping there is an easier way to get this working. Would greatly appreciate your input on this!

  • johanhaasbroek Profile Picture
    57 on 17 May 2022 at 06:56:20
    Re: Approval flow on SharePoint list modifications

    Good day Community, I am trying to do exactly this.

     

    When a sharepoint list is modified, an approval flow is triggered. If approved the modifications to the list gets saved, if rejected the modifications are ignored.

     

    Is there an easier way to do this now?

  • Community Power Platform Member Profile Picture
    on 04 Jun 2020 at 11:11:25
    Re: Approval flow on SharePoint list modifications

    Hi,

     

    Thank you for your help on this one. I'm trying to figure out which input (in the Compose action) to put in below:

    Flow screenshot.png

     

     

     

     

     

     

     

    Would this be the list item field I can pick up out of the "Parse VersionHistory JSON" block, or somewhere else? The linked article does not describe the correct input to go for in this instance.

     

    Thank you!

  • efialttes Profile Picture
    14,756 on 03 Jun 2020 at 16:24:25
    Re: Approval flow on SharePoint list modifications

    Hi again

    Can you share a screenshot from your current flow design? Sorry it's probably me, but from your text description I cannot figure out what is your new challenge

    Thanx!

  • Community Power Platform Member Profile Picture
    on 03 Jun 2020 at 07:39:00
    Re: Approval flow on SharePoint list modifications

    Hi @efialttes

     

    Thank you for the great help! I'm trying this in my flow (so far so good), but was wondering on the final step that is taken in the article you linked to. In the screenshot shown in the article, there is a final Compose action used to pick up the old value you would like to use later on in the flow (in this example the old office location):

     

    officelocation

     

     

     

     

     

     

     

    As the screenshot only shows the run results, I wanted to be sure about what to select here in building the flow. Would this be the list value (in this example office location) that can be picked up from the Parse VersionHistory JSON block?

     

    Thank you in advance for your continued help!!

  • v-alzhan-msft Profile Picture
    on 28 May 2020 at 06:27:30
    Re: Approval flow on SharePoint list modifications

    Hi @Anonymous ,

     

    The only solution should be as @efialttes  has provided.

     

    Best regards,

    Alice   

    Community Support Team _ Alice Zhang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • Verified answer
    efialttes Profile Picture
    14,756 on 27 May 2020 at 15:37:21
    Re: Approval flow on SharePoint list modifications

    Hi!

    You can activate 'Version history' on your Sharepoint list, and use 'Send HTTP request to Sharepoint' action block to get previous value if needed. It's a bit tricky, but works like a charm.

    Good stuff here

    https://www.catapultsystems.com/blogs/get-previous-versions-of-sharepoint-list-items-in-flow/

    Hope this helps

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - Building Flows

#1
David_MA Profile Picture

David_MA 276 Super User 2025 Season 1

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 234 Super User 2025 Season 1

#3
stampcoin Profile Picture

stampcoin 210

Overall leaderboard
Loading started