Posting news in Sharepoint. Flow triggers only once in Draft state

(0) Share

Report

Posted on by zigfridus

Hello

I created new Flow for the Sharepoint site, which should send an email when new post is Published.

But it doesn't send an email if the post is in the Draft state already. As I understand my Flow already triggered, when the new post swtched to the Draft state and after that when I press publish button it doesn't trigger.

It does work when a post still isn't in the Draft state.

Could you plese tell me how can I fix it?

Thanks

Annotation 2019-06-26 110437.jpg

Categories:

Using flows

I have the same question (0)

All responses (6)

Answers (0)

Sort by

Pstork1 69,485 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

The only real difference between a draft and published is that the published version is a major version and the minor version is draft. Taht means the when a file is created won't fire when the page is published. YOu'll need to change your flow to fire when the files is created or modified and then check to see if the version is a major version or not.

The problem is I don't know any way to retrieve the current version number of the document. So I don't know how you determine whether this is a major published version or not.

Was this reply helpful? Yes No
Pstork1 69,485 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
Here are two workarounds that should work.
You can retrieve the current version # of the document using the Send an HTTP request to SharePoint action. Then you can have your FLOW only send the email when a major version is published.
If you run the FLOW connector as an account that only sees the major versions then the File create Trigger will only fire when a major version is Published.
I suspect #2 is the better choice but it means creating and running the Flow with a different user context that has lessor permissions to the site. Not sure if that's convenient. #1 will also work but it requires changing the trigger and will lead to more Flow runs.

Was this reply helpful? Yes No
zigfridus 21 on at

Like (0)

Report
Copy link

Link copied!

Thank you for your answer. I've tried to get the file's version from HTTP request but it wasn't successful.
Could you please tell me what is wrong in this request:
_api/web/GetFolderByServerRelativeUrl('/SitePages')/Files('FullFileName')?$select=FileLeafRef,OData__UIVersionString

Was this reply helpful? Yes No
Pstork1 69,485 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

Take a look at John Liu's blog post on getting the version number.

http://johnliu.net/blog/2018/5/microsoft-flow-sharepoint-trigger-on-specific-fields-changed-via-sp-http-request

Was this reply helpful? Yes No
Pstork1 69,485 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
I played around with it a little since John's post is for List items. Here's the right REST call
https://acmee3.sharepoint.com/sites/FlowDemos/_api/web/GetFolderByServerRelativeUrl('SitePages')/Files('Home.aspx')?$select=FileLeafRef,UIVersionLabel
Two changes from yours.
Remove the slash form Site pages. It needs to be server relative not absolute.
retrieve UIVersionLabel. If that value is a whole number its major (ie. 1.0, 2.0, 3.0)

Was this reply helpful? Yes No
zigfridus 21 on at

Like (0)

Report
Copy link

Link copied!

I'm very sorry for the delay.
I've got another important task and have to complete it.
After that I'll try to do that You adviced me.
Thanks

Was this reply helpful? Yes No