Jun 02 2020 07:15 AM
Hi all,
I hope you can help. Can I promote a document on SharePoint as news? If so, can I automate this process so that it posts automatically at the end of every Wednesday?
Would it also be possible to generate an email of the content to my manager within the same flow?
Any advice would be much appreciated!
Thanks,
Luisa
Jun 02 2020 07:47 AM
Solution@Ldavidson what you can do is to have a Word document uploaded to a documents library on your SharePoint site. Then copy the link to it. Next, instead of adding a news post you add a news link and paste in the URL you copied:
Currently there is no feature to schedule a news post or a news link but it's being worked on by Microsoft (https://sharepoint.uservoice.com/forums/329214-sites-and-collaboration/suggestions/32233861-schedule...). So for the time being the only thing you can do is that when you create a news link it actually creates a page in the Site Pages library. So you could create the news link and immediately un-publish it & switch it back to draft, then use a flow in Power Automate to change the PromotedState to 2, i.e a published new page, every Wednesday. It's a bit of a hack though.
The content of the news link item could be sent to your manager in an email via the same flow but I'd be tempted to wait until we can schedule a news page.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Jun 02 2020 08:17 AM
@RobElliott How can you change the PromotedState, isn't that embedded in the HTML for the page itself?
Jun 02 2020 09:00 AM - edited Jun 02 2020 09:19 AM
@bri992 no, you can manually change a PromotedState value or use a flow to do it.
Manually change the PromotedState
Click on the dropdown next to any column header and in Column settings select Show/hide columns. Next, check the PromotedState column. Save the view. Then go to Quick Edit and you can change the PromotedState to 0 (normal published page), 1 (draft news page) or 2 (published news page.)
Change the PromotedState in a flow
Again make sure the PromotedState column is visible in the (usually) All items view. Then in your flow add a SharePoint Update item action to change the flow to 2 (published news):
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Jun 02 2020 10:37 AM
that's why when I tried to modify the view, this column doesn't appear. show and hide columns showed it
Jun 02 2020 10:40 AM
Jun 02 2020 10:43 AM
@bri992 you must make sure that you have saved the view of the list with the PromotedState column in it.
Rob
Los Gallardos
Microsoft Power Automate Community Super User
Jun 02 2020 10:49 AM
I can see the column now in quick edit but it's disabled. maybe I should use flow for that?
Jun 03 2020 01:18 AM
@RobElliottThanks Rob that's super helpful for the new post and for the potential way round automation! Good to know it's in development. I will definitely give this a go.
Jun 02 2020 07:47 AM
Solution@Ldavidson what you can do is to have a Word document uploaded to a documents library on your SharePoint site. Then copy the link to it. Next, instead of adding a news post you add a news link and paste in the URL you copied:
Currently there is no feature to schedule a news post or a news link but it's being worked on by Microsoft (https://sharepoint.uservoice.com/forums/329214-sites-and-collaboration/suggestions/32233861-schedule...). So for the time being the only thing you can do is that when you create a news link it actually creates a page in the Site Pages library. So you could create the news link and immediately un-publish it & switch it back to draft, then use a flow in Power Automate to change the PromotedState to 2, i.e a published new page, every Wednesday. It's a bit of a hack though.
The content of the news link item could be sent to your manager in an email via the same flow but I'd be tempted to wait until we can schedule a news page.
Rob
Los Gallardos
Microsoft Power Automate Community Super User