cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Warnolf
Level: Powered On

I'm going crazy: Modify file properties in SharePoint after approval creates a loop

There is a template in Flow called "Modify file properties in SharePoint after approval" which I thought was excellent for my needs. But, of course, that creates a loop and the file is always pending approval.

 

So my needs are this: 

1. Whenever someone publishes a major version of a document, it should trigger approval.

2. After the approval flow is done, the name of the approver and the date of the approval is visible in their respective site collection columns. 
I can do it with the mentioned template, but of course those column changes trigger a new approval and the race is on... 

 

If the Publish action is a problem I am not against the notion of having only major versions. But that is not the big issue, right?

 

1 ACCEPTED SOLUTION

Accepted Solutions
Warnolf
Level: Powered On

Re: I'm going crazy: Modify file properties in SharePoint after approval creates a loop

Hey @edgonzales!

I cracked it. But it was HARD getting there. 

I'm attaching a Snagit PNG of my flow just in case anyone else is wondering how this was done.

First: I did it by selecting a file in my document library and requested to create a flow for it. I selected the template:  Request manager proposal for a selected file. Then I removed all the actions except the first one ("For a selected file") and then I built the flow to my liking. 

Once I understod that chain of multiple "Set content approval status" I could easily get a working flow. 

Thanks for the encouragement. 

 

/Mats

 

2019-07-29_16-01-51.png

View solution in original post

8 REPLIES 8
Super User
Super User

Re: I'm going crazy: Modify file properties in SharePoint after approval creates a loop

@Warnolf 

Hi there!  I'm not super familiar with this template, but it seems like you could put a condition between the trigger and the first action (approval) to check the fields that your updating on the "Yes" path of the approval.  Would that suit your needs?20190719a.PNG

Keep us posted, either way.

 

-Ed-

 

 

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Warnolf
Level: Powered On

Re: I'm going crazy: Modify file properties in SharePoint after approval creates a loop

it would stop the loop, but would the document status not still be pending since it has changed? I mean, the flow won't trigger but the change would still be "post approval", right?

Super User
Super User

Re: I'm going crazy: Modify file properties in SharePoint after approval creates a loop

Nothing at all should change because the Flow will stop at that point.  If you want, post what the Update File Properties step looks like to be sure, but it's not going to do anything unless you tell it to.

 

-Ed-

 

If this reply has answered your question or resolved your challenge, please consider marking it as a Solution. This helps other users find it more easily via search.

Warnolf
Level: Powered On

Re: I'm going crazy: Modify file properties in SharePoint after approval creates a loop

Well, call me stupid but I dont get it. Smiley Embarassed

  1. I change the document (Version is updated)
    1. Flow Approval process is triggered
      1. Checks if [gate column] is set to True
        1. If False the process ends, but the version is still new and the approval is pending
        2. If True the process continues, approves the changes and populates the "approved by", "approval date" etc which is in itself a new change, that requires approval. 

So. I wish that the changes to this specific metadata would not be considered a change to the document. Or that the metadata would be written before the actual approval. 

Highlighted
Super User
Super User

Re: I'm going crazy: Modify file properties in SharePoint after approval creates a loop

@Warnolf 

You can do all of that if you want.  Don't feel like you need to use the template exactly as it is.  Maybe come at it from a different angle:  Try sketching the process out the way you want it, and we can manipulate the Flow to do that.

 

-Ed-

Warnolf
Level: Powered On

Re: I'm going crazy: Modify file properties in SharePoint after approval creates a loop

Hey @edgonzales , thanks for reminding me about my mindset. Instead of being frustrated with what I dont have, or what I think I dont have, go back to look what I do have. Smiley Happy
It is evening in Sweden and I will have a fresh look tomorrow and do exactly what you suggested. Ignore the ready made things, look at the individual lego pieces and see what I can build with it. 

 

Warnolf
Level: Powered On

Re: I'm going crazy: Modify file properties in SharePoint after approval creates a loop

I still can't make this flow work. So here is my description of what I need.

 

This is a document library. The library contains documents of a specific content type that have custom columns including documentID, Approver, Valid date etc. These all displayed in the document header inside the document. 

When a document is updated it needs to be reviewed and approved before it gets to be the current version. 

 

My plan was this: 

  1. Turn on minor versions
  2. Create an approval flow so that if approved
    1. Updates the column "Approved by" with the name of the approver
    2. Updates the column "Valid date" with the date approved 
    3. Publishes the document as a major version
  3. This approval flow should only run when someone requests to publish it as a major version. 

Simple, I thought. Creating a flow can be a very humbling experience.

 

/Mats

 

Warnolf
Level: Powered On

Re: I'm going crazy: Modify file properties in SharePoint after approval creates a loop

Hey @edgonzales!

I cracked it. But it was HARD getting there. 

I'm attaching a Snagit PNG of my flow just in case anyone else is wondering how this was done.

First: I did it by selecting a file in my document library and requested to create a flow for it. I selected the template:  Request manager proposal for a selected file. Then I removed all the actions except the first one ("For a selected file") and then I built the flow to my liking. 

Once I understod that chain of multiple "Set content approval status" I could easily get a working flow. 

Thanks for the encouragement. 

 

/Mats

 

2019-07-29_16-01-51.png

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

firstImage

Incoming: New and improved badges!

We've given our badges an overhaul and also added some brand new ones!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors (Last 30 Days)
Users online (5,209)