SOLVED
Home

Automatically publishing News Articles based on Microsoft Flow Approvals

%3CLINGO-SUB%20id%3D%22lingo-sub-149779%22%20slang%3D%22en-US%22%3EAutomatically%20publishing%20News%20Articles%20based%20on%20Microsoft%20Flow%20Approvals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149779%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EFor%20our%20intranet%20we're%20trying%20to%20actively%20allow%20editors%20in%20our%20organization%20to%20post%20content%20such%20as%20news%20and%20blog%20articles.%20We're%20using%20the%20Modern%20Communication%20Site%20as%20a%20template.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20basic%20idea%20we%20had%20is%20as%20follows%3A%3C%2FP%3E%0A%3COL%3E%0A%3CLI%3EEditors%20to%20write%20a%20page%20and%20save%20that%20page%20as%20a%20draft.%3C%2FLI%3E%0A%3CLI%3EWhen%20the%20draft%20is%20saved%2C%20catch%20the%20creation%20of%20a%20new%20item%20in%20Flow%20and%20trigger%20an%20Approval.%3C%2FLI%3E%0A%3CLI%3EThe%20Editor-in-Chief%20checks%20the%20article%2C%20makes%20changes%20if%20needed%20and%20approves%20it.%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3EUp%20on%20approval%2C%20we%20update%20the%20PromotedState%20of%20the%20draft%20to%202%20(which%20is%20the%20Published%20state)%20to%20get%20it%20to%20show%20up%20as%20a%20news%20article.%26nbsp%3B%3C%2FLI%3E%0A%3CLI%3EEditor%20is%20notified%20that%20the%20article%20is%20published.%26nbsp%3B%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F27590i13E7B440EECC11B6%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22approval.png%22%20title%3D%22approval.png%22%20%2F%3E%3C%2FSPAN%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3C%2FLI%3E%0A%3C%2FOL%3E%0A%3CP%3EThe%20only%20hiccup%20we're%20experiencing%20right%20now%20is%20that%20the%20updating%20of%20the%20PromotedState%20via%20this%20method%20does%20not%20have%20the%20same%20effect%20as%20actually%20pressing%20the%20'Publish'%20button%20on%20the%20Draft%20page%2C%20the%20page%20is%20still%20in%20Draft.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%26nbsp%3B%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20style%3D%22width%3A%20775px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F27591i2CE5D1EE4645B5D1%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20alt%3D%22promotedstates.png%22%20title%3D%22promotedstates.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%0A%3CP%3EDoes%20anyone%20know%20of%20a%20way%20to%20trigger%20the%20actual%20publishing%20based%20on%20this%20scenario%2C%20or%20is%20this%20not%20yet%20possible%20and%20will%20we%20need%20to%20do%20this%20manually%3F%20Thanks%20in%20advance!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-149779%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECommunication%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3Emodern%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ENews%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-224855%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20publishing%20News%20Articles%20based%20on%20Microsoft%20Flow%20Approvals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-224855%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20you%20have%20Content%20Approval%20turned%20on%20in%20the%20Sites%20Pages%20library%20and%20the%20page%20author%20submits%20for%20approval.%20Flow%20can%20set%20the%20approval%20status%20to%20Approve%20which%20will%20publish%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-150839%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20publishing%20News%20Articles%20based%20on%20Microsoft%20Flow%20Approvals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-150839%22%20slang%3D%22en-US%22%3EBummer.%20I%20thought%20that%20you%20could%20do%20that%20by%20now%20%3A(.%20Guess%20I%20heard%20it%20was%20being%20worked%20on%20too%20and%20thought%20it%20had%20been%20released.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-150700%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20publishing%20News%20Articles%20based%20on%20Microsoft%20Flow%20Approvals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-150700%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20Christopher%2C%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20seems%20that%20there%20is%20currently%20no%20way%20to%20check%20in%20a%20file%20or%20page%20with%20Flow.%20It%20seems%20like%20the%20functionality%20is%20currently%20planned%2C%20but%20not%20available%20yet.%20Thanks%20for%20the%20response!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149928%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20publishing%20News%20Articles%20based%20on%20Microsoft%20Flow%20Approvals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149928%22%20slang%3D%22en-US%22%3EI%E2%80%99m%20very%20much%20looking%20forward%20to%20OOTB%20publishing%20being%20implemented%20in%20the%20modern%20experience%20of%20SharePoint.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149892%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20publishing%20News%20Articles%20based%20on%20Microsoft%20Flow%20Approvals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149892%22%20slang%3D%22en-US%22%3EI%20know%20they%20are%20also%20working%20on%20approval%20process%20function%20for%20site%20pages%2F%20news%20like%20in%20the%20old%20SharePoint%20that%20is%20coming%2C%20but%20I%20think%20you%20should%20still%20be%20able%20to%20use%20flow%20to%20do%20this.%20Curious%20if%20that%20works.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-149891%22%20slang%3D%22en-US%22%3ERe%3A%20Automatically%20publishing%20News%20Articles%20based%20on%20Microsoft%20Flow%20Approvals%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-149891%22%20slang%3D%22en-US%22%3EThe%20document%20gets%20checked%20out%20basically%20when%20it's%20in%20Draft%2C%20Checked%20in%20%3D%20published%2C%20maybe%20try%20throwing%20a%20step%20in%20there%20for%20checking%20in%20after%20the%20promoted%20state%20goes%20to%202%3F%3C%2FLINGO-BODY%3E
Highlighted
Evert Eckhardt
New Contributor

Hi all, 

 

For our intranet we're trying to actively allow editors in our organization to post content such as news and blog articles. We're using the Modern Communication Site as a template.

 

The basic idea we had is as follows:

  1. Editors to write a page and save that page as a draft.
  2. When the draft is saved, catch the creation of a new item in Flow and trigger an Approval.
  3. The Editor-in-Chief checks the article, makes changes if needed and approves it. 
  4. Up on approval, we update the PromotedState of the draft to 2 (which is the Published state) to get it to show up as a news article. 
  5. Editor is notified that the article is published. approval.png

     

The only hiccup we're experiencing right now is that the updating of the PromotedState via this method does not have the same effect as actually pressing the 'Publish' button on the Draft page, the page is still in Draft.

   

promotedstates.png

Does anyone know of a way to trigger the actual publishing based on this scenario, or is this not yet possible and will we need to do this manually? Thanks in advance!

6 Replies
The document gets checked out basically when it's in Draft, Checked in = published, maybe try throwing a step in there for checking in after the promoted state goes to 2?
Solution
I know they are also working on approval process function for site pages/ news like in the old SharePoint that is coming, but I think you should still be able to use flow to do this. Curious if that works.
I’m very much looking forward to OOTB publishing being implemented in the modern experience of SharePoint.

Hi Christopher, 

 

It seems that there is currently no way to check in a file or page with Flow. It seems like the functionality is currently planned, but not available yet. Thanks for the response!

Bummer. I thought that you could do that by now :(. Guess I heard it was being worked on too and thought it had been released.

If you have Content Approval turned on in the Sites Pages library and the page author submits for approval. Flow can set the approval status to Approve which will publish it.

Related Conversations
WorkBook Calculation automatic mode
kbnreddy2002 in Excel on
2 Replies
PowerShell: Find VNet of an ARM VM
Christian Forjahn in Azure on
4 Replies
DNS configuration
Nisal S.Wijerathna in Azure on
0 Replies
Azure Automation overview
Michael Holste in Azure on
0 Replies