Answered

Trigger an MS Flow if a file is published

(0) Share

Report

Posted on by Community Power Pla...

I'd like to have the team to work on documents stored in a specific sharepoint folder undisturbed. However, whenever they think that a document is to leave the draft status and is ready for plublication (i.e. whenever they publish a document) I would like to trigger an approval flow. My approach boils down to this:

1- get the file details using a SharePoint: When a file is created or modified (properties only action)

2- Setup a condition that would test whether the Approval Status was changed to Pending.

3A - If it is set to Pending, then start the approval flow

3B - If it is not set to pending, then ingore the trigger - since it is caused by another event

I can't figure out how to write the condition, i.e. how to set it up so that i can test the Approve Status Value. (identify whether the trigger is fired by a publish action)

Any thoughts?

All responses (4)

Answers (1)

jlni01 3 on at

Like (0)

Report

Re: Trigger an MS Flow if a file is published

Any solution to this? My closest attempt is

1.) When a file is created
2.) start Approval flow
3a.) Set content approval status: Submit
3b.) Set content approval status: Approve
BadGateway error because file is "Draft"
----
Janky solution:
1.) When a file is created
Here user must manually Check-In file and then Publish file (this must happen immediately and before the approver clicks "approve")
2.) start Approval flow
3a.) Set content approval status: Submit
3b.) Set content approval status: Approve
File is published

Thus, no good solution yet. Have checked many forum posts and tinkered with many options in PowerAutomate with no success.
stevejhh 5 on at

Like (1)

Report

Re: Trigger an MS Flow if a file is published

Same here... Have you found a solution?
stefgerardi 4 on at

Like (1)

Report

Re: Trigger an MS Flow if a file is published

Hi, I would like to do the same but only when a news post is published on SharePoint. I've set up a flow on power apps and it works but it sends out a notification via email and teams as soon as I create a new post, which is not what i want because i dont even get a chance to name the post and it straight away sends out a notification whilst the post is still a draft before even publishing it. Can anyone help me out? I am not able to view the link listed above either.
Verified answer

Community Power Pla... on at

Like (0)

Report

Re: Trigger an MS Flow if a file is published

i've found an alternative here: https://powerusers.microsoft.com/t5/Flow-Cookbook/Publish-approval-manual-flow/td-p/79600
this is needed since Flow doesn't yet support publish triggers

Community site session details

Trigger an MS Flow if a file is published

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Leaderboard > Power Automate

Featured topics

Product updates

Community site session details

Trigger an MS Flow if a file is published

Helpful resources

News and Announcements

Quick Links

Paul Stork – Community Spotlight

Congratulations to the June Top 10 Community Leaders!

Announcing the Engage with the Community forum!

Subscribe to this forum!

Select categories

Leaderboard > Power Automate

Featured topics

Product updates