cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Abhiman
New Member

Automate Status Update Post Modification for Approved/Rejected Documents

I have utilised the “Request approval in Teams for a selected item in SharePoint” automate template. I have manually added a status column that tracks the progress (For approval, Approved, Rejected).  This is working  fine.

 

 

 However, when a user modifies an Approved/Rejected document, I want the status column to change back to draft. I catered for this by creating a second flow. An automated flow using the trigger "when an item is created and modified" , added a condition that if the status is equal to Approved/Rejected then update file properties ( update Status field to "Draft")

My problem is when the approval workflow updates the status to Approved/Rejected... it then triggers my second flow which converts it back to draft status ?  When I would actually only what the second flow to trigger, when its modified for the first time post approval/rejection.

 Business Requirement: When a user modifies an Approved/Rejected document then the status should be updated to Draft.

Thanks in advance for your help!

1 REPLY 1
alrez
Community Support
Community Support

Hi,

 

If you set up your Flow to trigger "When a Sharepoint item is create or modified" It will trigger every time that happens. You could add a few conditions to terminate the Flow early but it will have to be based on something. What you need is another field to check to see how many times its been modified and its been modified more then twice it will skip the flow run.

 

Regards,

 

Alex

 

-------

 

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

Helpful resources

Announcements
MPA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

R2 (Green) 768 x 460px.png

Microsoft Dynamics 365 & Power Platform User Professionals

DynamicsCon is a FREE, 4 half-day virtual learning experience for 11,000+ Microsoft Business Application users and professionals.

Top Solution Authors
Users online (1,625)