Forum Discussion

andrewparrish's avatar
andrewparrish
Copper Contributor
Nov 16, 2021

Filtering News posts across sites using tags or categories

Hi all. We are in the process of creating an intranet 2.0 in my organization and the question has come from on high as to whether it would be possible to feed specific news articles up to an intranet home page from a different site associated with the intranet hub site. I am currently exploring some form of universal tags or something of that nature that could fulfill this task but I wanted to seek insight from the group for alternatives if that doesn't pan out/exist. Any and all advice/guidance is greatly appreciated.

  • SusanHanley's avatar
    SusanHanley
    Nov 29, 2021
    This is definitely an advanced skill, but it is not hard to do. I am not aware of any step by step instructions for how to do it but here is a quick way to do a demo to show how it works. You will need to learn about managed metadata, site columns, and the News web part for this to work - as well as options for provisioning sites (which is a completely different topic that you'll want to research). Once you are familiar with these basic terms, here's what you can do. Let's say you want to categorize all news on any site with a News Type. To do that, first create a Term Set in the SharePoint Admin Center for News Types. Make sure each value is unique. Then, create a managed metadata site column on each site called News Type and point the column to the term set you created at the root of your tenant. Add the site column to the Site Pages library on your sites. Now, every site has a column with the exact same name and a shared set of values. You will need to actually create and publish pages with the values for this to work, but once you've got all your content created, you can select the sites you want to roll up in the News Source and then filter using a Managed Property. Find the column you created (it will have a name like owstaxIdNewsType) and use filter options to find Property Name Contains whatever term you are looking to roll up. You have several options for making sure all sites get created with the appropriate columns, but your goal is to ensure that all sites are provisioned with the columns that you need.
  • RobElliott's avatar
    RobElliott
    Silver Contributor

    andrewparrish if you are feeding flows up to the hub site from an associate site, it will feed up all the news posts, you can't specify which posts will flow up.

     

    Rob
    Los Gallardos
    Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

    • andrewparrish's avatar
      andrewparrish
      Copper Contributor
      thanks for the response and the confirmation that filtering specifically tagged posts cannot appear on an intranet site (instead all posts from the sub-site).
  • Sderix's avatar
    Sderix
    Brass Contributor
    Maybe I am missing something here but you can aggregate news based on (managed) metadata. So this requirement should be possible IF you can tag it somehow - manually or automated
  • andrewparrish Yes, you can create a news web part on Site A that pulls up only News articles from Site B that have a specific managed property. The editor on Site A needs to know the property name and values used on Site B in order to write the query and the property needs to be a managed property, but it is definitely possible if you have metadata on the pages in Site B. 

    • andrewparrish's avatar
      andrewparrish
      Copper Contributor

      SusanHanley Hi! Thank you for the confirmation that it should be possible. I am trying to get this working to show to my VP as we undergo a major facelift of our small intranet. 

      At the moment I am able to get it to recognize columns within the same page, but I am having no success with the hub site recognizing a column on the site pages page on site B. 

       

      Do you by chance no of any blog posts or further instructions that could walk me through this? My SharePoint skills are still in their toddler phase.

      • SusanHanley's avatar
        SusanHanley
        MVP
        This is definitely an advanced skill, but it is not hard to do. I am not aware of any step by step instructions for how to do it but here is a quick way to do a demo to show how it works. You will need to learn about managed metadata, site columns, and the News web part for this to work - as well as options for provisioning sites (which is a completely different topic that you'll want to research). Once you are familiar with these basic terms, here's what you can do. Let's say you want to categorize all news on any site with a News Type. To do that, first create a Term Set in the SharePoint Admin Center for News Types. Make sure each value is unique. Then, create a managed metadata site column on each site called News Type and point the column to the term set you created at the root of your tenant. Add the site column to the Site Pages library on your sites. Now, every site has a column with the exact same name and a shared set of values. You will need to actually create and publish pages with the values for this to work, but once you've got all your content created, you can select the sites you want to roll up in the News Source and then filter using a Managed Property. Find the column you created (it will have a name like owstaxIdNewsType) and use filter options to find Property Name Contains whatever term you are looking to roll up. You have several options for making sure all sites get created with the appropriate columns, but your goal is to ensure that all sites are provisioned with the columns that you need.
  • FOCon80's avatar
    FOCon80
    Copper Contributor

    andrewparrish is it possible to filter OUT using keywords?

    I'm pulling news from several sites into a central feed and I want to filter OUT specific items based on a keyword.

    • andrewparrish's avatar
      andrewparrish
      Copper Contributor

      FOCon80 to the best of my knowledge there is no native way to filter OUT keywords. You can only filter BY keywords in a Title. The only solution would be to get users to tag posts, then you could use the method outlined in the thread to exclude posts with specific tags/managed properties. 

       

      Susan_Hanley thank you for taking on responding to everyone of my initial post. I left my job over a year ago and now I have returned, surprised at how my original post has gotten some traction.

      • FOCon80's avatar
        FOCon80
        Copper Contributor
        That's what I was afraid of.. thank you kindly for taking the time to respond.

Resources