Forum Discussion
Change News Page to Site Page
Ok, I finally got this to work without Using flow. Do the following.
1.Go to Site Pages on your Site.
2.Change your view to "All Items"
3.Now Click the + to add a column to view, and select Show/Hide Columns
4.Check Promoted State column and click "Apply" at the top.
5.Now Click the view drop down and Save view as
6.Name it "All Items and State"
7.Now you should be able to click "Quick Edit" and then Promoted State column will be exposed to change the value. Change the page you no longer want to be news from 2 to 0 and Click exit and your page can now be a Site page again.
Ok, I finally got this to work without Using flow. Do the following.
1.Go to Site Pages on your Site.
2.Change your view to "All Items"
3.Now Click the + to add a column to view, and select Show/Hide Columns
4.Check Promoted State column and click "Apply" at the top.
5.Now Click the view drop down and Save view as
6.Name it "All Items and State"
7.Now you should be able to click "Quick Edit" and then Promoted State column will be exposed to change the value. Change the page you no longer want to be news from 2 to 0 and Click exit and your page can now be a Site page again.
- That doesn't work for me in SharePoint in Microsoft 365 because the Promoted State is 'read-only', even when editing in grid view. Some time ago, found a json code to put on the Promoted State column. It allows you to change the promoted state from 2 to 1 or 0, but doesn't let you go the other way. I hope it helps you and sorry I don't have the name of the original author. A box of Krispy Kream donuts for anyone who can tell me how to make it go the other way too. 🙂
{
"$schema": "https://developer.microsoft.com/json-schemas/sp/v2/column-formatting.schema.json",
"elmType": "div",
"style": {
"flex-wrap": "wrap",
"display": "flex",
"flex-direction": "row"
},
"children": [
{
"elmType": "div",
"txtContent": "=if(@currentField == 0 ,'0 : Page' , if(@currentField == 1, '1 : News (Unpublished)' , if(@currentField == 2 , '2 : News','') ) )",
"style": {
"box-sizing": "border-box",
"padding": "4px 8px 5px 8px",
"display": "flex",
"border-radius": "16px",
"height": "27px",
"align-items": "center",
"white-space": "nowrap",
"overflow": "hidden",
"margin": "4px 4px 4px 4px",
"border": "1px solid"
},
"attributes": {
"class": "=if(@currentField == 0 ,'ms-fontColor-themePrimary ms-borderColor-themePrimary ms-bgColor-white' , if(@currentField == 1, 'ms-fontColor-themePrimary ms-borderColor-themePrimary ms-bgColor-themeLighter' , if(@currentField == 2 , 'ms-fontColor-white ms-borderColor-themePrimary ms-bgColor-themePrimary','') ) )"
}
},
{
"elmType": "div",
"style": {
"font-size": "18px",
"cursor": "pointer",
"padding": "10px",
"border-radius": "50%",
"display": "=if(@currentField == 0 , 'none' ,'')"
},
"attributes": {
"iconName": "MoreVertical",
"class": "ms-fontColor-themePrimary ms-bgColor-themeLighter--hover"
},
"customCardProps": {
"openOnEvent": "click",
"directionalHint": "rightCenter",
"isBeakVisible": true,
"formatter": {
"elmType": "div",
"txtContent": "Demote (Change to 0:Page)",
"style": {
"padding": "10px 20px 10px 20px",
"cursor": "pointer"
},
"attributes": {
"class": "ms-bgColor-themeLighter--hover"
},
"customRowAction": {
"action": "setValue",
"actionInput": {
"PromotedState": "0"
}
}
}
}
}
]
} I tried this by when I try to change 2 to 0, it says cell is "read only"... I am a site owner. Any suggestions?
I dont't get this Quick Edit option, only "Edit in grid view" and then it says the cell for Promoted State is read only, so I can't change it. Any ideas on what I should do?
carlosxjunior you can see my post on how to change the promoted state at https://techcommunity.microsoft.com/t5/sharepoint/sharepoint-news-post-still-appears-even-after-the-news-page-has/m-p/3291560/highlight/true#M59373
Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)- If this worked in April 2022, I'm afraid Microsoft have closed that loophole now too. They really don't want us messing with this field - which remains read-only. But still we appear to have no "Demote" option available as standard... so still we scratch our heads over what to do about mistakenly promoted pages... I'm afraid my Admin blocks the use of SPFx extensions like the one mentioned above - but hopefully that option is still available (and still works) for some of you.
Thank you so much for this solution. Worked well for me. One question left, just to be shure, is it after i've change the state from "2" to "0", necessary to rename the column back to "Promoted state"? Or is it ok to keep this at "All Items and State"?
I am unable to edit the Promoted State value. This field appears to be readonly.
- If you want to edit the Promoted State there is a easy way and I just found that just go to the Promoted state column --> Column settings --> edit ---> Don't change anything just save the column and now that Promoted can be found in the page details where the field will be editable and Hope this helps for everyone out there.
You are awesome. Your workaround works perfectly! Thank you!
I have tried to test this on one of our modern sites, however, I do not see Promoted State in the available columns. Is there something missing, or do I lack permission to do this?
Edit: nevermind, I found it. You HAVE to use show/hide columns to do this. It's not available in Edit View.
- Promoted State is one of the "modern" columns. You will need to "expose" it from a view of Site Pages by selecting "Add column" and then "Show/hide columns." When you do that, you will be able to check the box in front of Promoted State and click Apply. Be sure to save your view. Once you have done this, you should be able to add Promoted State to any view using the Edit View link.
FYI - I'm curious if anyone else has tried this lately since it no longer appears to work. Dragging and dropping it from one state group to another doesn't change the site page Promoted State value.
- Also, I don't use drag and drop, I use quick edit as shown in the gif, Make sure you edit a view with quick edit and save it, sometimes quick edit disappears right after save, just do an F5 refresh of browser and it will come back.
Thank you for the animated gif. It's very useful to make sure every step was the same. Still no luck for me. Enclosed is the relevant part of the problem. For some reason, I can't edit that column.
Yes, I just did it, see gif. I'll try on targeted release to see if I can do there as well, but on standard still working.
- Working on Targeted release as well.
Ok, so I used the trick of exposing the column, saving the view, the using quick edit to change the 2 to 0 for a couple of pages.
if I add a news web part to the site where the page is located, the page doesn't show up any more! Great!
BUT! I have added a news web part to the hub site. The edited pages are still showing up at the hub level. I've deleted the web part, deleted the page its on, recreated everything...but they still show up on the hub site.
any advice for this situation? I've opened a case with our cloud support, I will update if I get helpful results from them
- Those news articles are search cached. You have to give it time for the crawl to happen but if you delete a news article it should go away I think in roughly 10 minutes or so.
I waited overnight, no change.
and just to be clear, I didn't delete the pages, I just changed their value in the "Promoted State" column.
