Answered

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

(0) Share

Report

Posted on by Community Power Pla...

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?

Categories:

Building flows

I have the same question (0)

All responses (12)

Answers (1)

Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

@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?

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.

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

Like (0)

Report

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?

Was this reply helpful? Yes No
Ed Gonzales 4,531 Most Valuable Professional on at

Like (0)

Report

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.

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

Like (0)

Report
Well, call me stupid but I dont get it.
I change the document (Version is updated)
Flow Approval process is triggered
Checks if [gate column] is set to True
If False the process ends, but the version is still new and the approval is pending
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.

Was this reply helpful? Yes No
Ed Gonzales 4,531 Most Valuable Professional on at

Like (1)

Report

@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-

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

Like (1)

Report

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.
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.

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

Like (0)

Report
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:
Turn on minor versions
Create an approval flow so that if approved
Updates the column "Approved by" with the name of the approver
Updates the column "Valid date" with the date approved
Publishes the document as a major version
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

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (1)

Report

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

Was this reply helpful? Yes No
BigAl1 2 on at

Like (0)

Report

@Warnolf

I am getting a very similar problem and I would really like to use your solution but the image is too small for me to read. Could you repost the solution in a larger format?

Thanks
Alan

Was this reply helpful? Yes No
tpyne 6 on at

Like (0)

Report

@Warnolf , Same here, I am running into the same issue.

If I change file properties it sets the approval status back to pending for some reason.
I have a 2 stage approval process setting the item to approved when the second approval succeeds. This works.
But as soon as I change the properties the approval status goes back to pending. Don't know why.

I am really interested in viewing your solution.

It it could be posted at a readable size that would be greatly appreciated. When expanding it, it just gets blurry

Was this reply helpful? Yes No