SOLVED

Highlighted Content Web Part - Issues filtering items with Managed Properties

%3CLINGO-SUB%20id%3D%22lingo-sub-2279371%22%20slang%3D%22en-US%22%3EHighlighted%20Content%20Web%20Part%20-%20Issues%20filtering%20items%20with%20Managed%20Properties%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2279371%22%20slang%3D%22en-US%22%3E%3CP%3EWould%20someone%20please%20be%20able%20to%20explain%20why%20I%20can't%20get%20the%20%22Highlighted%20Content%22%20web%20part%20to%20accurately%20filter%20and%20display%20files%20based%20on%20the%20custom%20fields%20I've%20picked%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3EContext%3C%2FSTRONG%3E%3A%26nbsp%3B%20I%20have%20a%20library%20of%20PowerPoint%20files%20sitting%20in%20my%20department's%20SharePoint%20site%20(we'll%20call%20it%20%22Site%20A%22)%20that%20I%20want%20to%20share%20on%20our%20Sales%20department's%20SharePoint%20site%20(%22Site%20B%22).%26nbsp%3B%20%26nbsp%3BThis%20setup%20will%20allow%20me%20to%20update%20the%20files%20regularly%2C%20while%20only%20giving%20the%20sales%20staff%20READ%20permissions.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20%3CSTRONG%3ESite%20A's%3C%2FSTRONG%3E%20document%20library%2C%20I've%20added%20two%20custom%20fields%3A%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSTRONG%3ECourseStatus%26nbsp%3B%3C%2FSTRONG%3E-%20a%20%22Yes%2FNo%22%20field%20that%20controls%20whether%20or%20not%20a%20file%20can%20be%20viewed%20by%20the%20sales%20staff.%3C%2FLI%3E%3CLI%3E%3CSTRONG%3ECourseNames%3C%2FSTRONG%3E%20-%20a%20text%20field%20that%20includes%20the%20names%20of%20apps%20that%20each%20course%20covers%20(i.e.%3A%20SharePoint%2C%20Teams%2C%20Planner%2C%20etc.).%26nbsp%3B%3C%2FLI%3E%3C%2FUL%3E%3CP%3EBoth%20fields%20have%20been%20%3CSTRONG%3Eindexed%3C%2FSTRONG%3E.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EOn%20%3CSTRONG%3ESite%20B%3C%2FSTRONG%3E%2C%20I've%20created%20a%20page%20that%20is%20supposed%20to%20use%20the%20%22highlighted%20contents%22%20web%20part%20to%20display%20the%20PowerPoint%20files%20from%20Site%20A.%26nbsp%3B%20While%20displaying%20the%20files%20was%20easy%20enough%2C%20using%20the%20%22Managed%20Properties%22%20to%20filter%20based%20on%20those%20custom%20properties%20has%20not%20been.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22atrain204_0-1618949026369.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F274102i60B849B2C9A03ED3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22atrain204_0-1618949026369.png%22%20alt%3D%22atrain204_0-1618949026369.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHere%20are%20the%20problems%20I've%20come%20across%20when%20using%20the%20custom%20fields%20as%20filters%3A%3C%2FP%3E%3COL%3E%3CLI%3E%22CourseStatusOWSBOOL%22%20is%20set%20so%20only%20courses%20with%20a%20%22Yes%2F1%22%20value%20is%20displayed.%26nbsp%3B%20However%2C%20%3CSTRONG%3Eif%20I%20modify%20that%20value%20back%20to%20%22No%2F0%22%2C%26nbsp%3B%3C%2FSTRONG%3Ethat%20change%20is%20not%20reflected%20on%20this%20SharePoint%20page%20-%20even%20after%20over%2024%20hours%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLI%3E%3CLI%3E%22M365AppNamesOWSTEXT%22%20is%20used%20to%20filter%20courses%20by%20name.%26nbsp%3B%20However%2C%20this%20field%20doesn't%20seem%20to%20work%20as%20intended%20and%20I'm%20not%20sure%20what%20I'm%20doing%20wrong.%26nbsp%3B%20%26nbsp%3BI%20originally%20tried%20this%20with%20a%20%22Choice%22%20column%20type%20but%20with%20the%20same%20or%20worse%20results.%3C%2FLI%3E%3C%2FOL%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20will%20note%20that%20if%20the%20%22Highlighted%20Content%22%20web%20part%20works%20as%20expected%20on%20Site%20A%20(where%20I%20did%20my%20initial%20tests).%26nbsp%3B%20So%20I%20suspect%20that%20I%20don't%20fully%20understand%20how%20the%20%22Managed%20Properties%22%20works%20and%20need%20to%20know%20if%20I'm%20barking%20up%20the%20wrong%20tree.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2279371%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2279674%22%20slang%3D%22en-US%22%3ERe%3A%20Highlighted%20Content%20Web%20Part%20-%20Issues%20filtering%20items%20with%20Managed%20Properties%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2279674%22%20slang%3D%22en-US%22%3Ethanks!%20That%20article%20was%20just%20what%20I%20needed.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2279479%22%20slang%3D%22en-US%22%3ERe%3A%20Highlighted%20Content%20Web%20Part%20-%20Issues%20filtering%20items%20with%20Managed%20Properties%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2279479%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F423371%22%20target%3D%22_blank%22%3E%40atrain204%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3EI've%20found%20a%20recent%20article%20on%20the%20SharePoint%20Maven%20website%20-%20%3CA%20href%3D%22https%3A%2F%2Fsharepointmaven.com%2Fcrawled-vs-managed-properties-in-sharepoint-online%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3ECrawled%20versus%20Managed%20Properties%20in%20SharePoint%20Online%3C%2FA%3E%26nbsp%3Bthat%20I%20think%20might%20help%20you.%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3EUpshot%20of%20things%20is%20that%20when%20you%20have%20created%20your%20custom%20column%2C%20that%20becomes%20a%20crawled%20property%2C%20but%20you%20need%20to%20map%20that%20to%20a%20managed%20property%20so%20that%20you%20can%20use%20with%20the%20Highlighted%20content%20web%20part.%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20data-unlink%3D%22true%22%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2595075%22%20slang%3D%22en-US%22%3ERe%3A%20Highlighted%20Content%20Web%20Part%20-%20Issues%20filtering%20items%20with%20Managed%20Properties%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2595075%22%20slang%3D%22en-US%22%3EThank%20you%20Jenny%2C%20i%20have%20a%20new%20question%20%3A%20I%20created%20a%20hub%20with%20several%20associated%20sites.%20I%20want%20to%20filter%20certain%20content%20from%20all%20these%20sites%20(documents%2C%20pages%2C%20news)%20using%20highlighted%20content%20web%20part.%3CBR%20%2F%3EWhere%20should%20i%20create%20the%20custom%20fields%20as%20filters%20and%20map%20theme%20%3F%20in%20each%20site%20%3F%20in%20Hub%20only%20%3F%20or%20there%20is%20another%20way%20to%20do%20%3F%3C%2FLINGO-BODY%3E
Contributor

Would someone please be able to explain why I can't get the "Highlighted Content" web part to accurately filter and display files based on the custom fields I've picked? 

 

Context:  I have a library of PowerPoint files sitting in my department's SharePoint site (we'll call it "Site A") that I want to share on our Sales department's SharePoint site ("Site B").   This setup will allow me to update the files regularly, while only giving the sales staff READ permissions.

 

In Site A's document library, I've added two custom fields:

  • CourseStatus - a "Yes/No" field that controls whether or not a file can be viewed by the sales staff.
  • CourseNames - a text field that includes the names of apps that each course covers (i.e.: SharePoint, Teams, Planner, etc.). 

Both fields have been indexed.

 

On Site B, I've created a page that is supposed to use the "highlighted contents" web part to display the PowerPoint files from Site A.  While displaying the files was easy enough, using the "Managed Properties" to filter based on those custom properties has not been.

 

atrain204_0-1618949026369.png

 

Here are the problems I've come across when using the custom fields as filters:

  1. "CourseStatusOWSBOOL" is set so only courses with a "Yes/1" value is displayed.  However, if I modify that value back to "No/0", that change is not reflected on this SharePoint page - even after over 24 hours

  2. "M365AppNamesOWSTEXT" is used to filter courses by name.  However, this field doesn't seem to work as intended and I'm not sure what I'm doing wrong.   I originally tried this with a "Choice" column type but with the same or worse results.

 

I will note that if the "Highlighted Content" web part works as expected on Site A (where I did my initial tests).  So I suspect that I don't fully understand how the "Managed Properties" works and need to know if I'm barking up the wrong tree.

4 Replies
best response confirmed by atrain204 (Contributor)
Solution

Hi @atrain204 

I've found a recent article on the SharePoint Maven website - Crawled versus Managed Properties in SharePoint Online that I think might help you.

Upshot of things is that when you have created your custom column, that becomes a crawled property, but you need to map that to a managed property so that you can use with the Highlighted content web part.

 

 

thanks! That article was just what I needed.
Thank you Jenny, i have a new question : I created a hub with several associated sites. I want to filter certain content from all these sites (documents, pages, news) using highlighted content web part.
Where should i create the custom fields as filters and map theme ? in each site ? in Hub only ? or there is another way to do ?

Hi @Lamis ZOLHOF 

I would recommend that you set up content types in the Content type gallery that you'll find in the Content Services part of SharePoint Admin centre.  

In the process of setting up your content types you'll create custom columns that can be used across all your SharePoint site collections.  

For more info see Microsoft Docs Create or customise a content type

The SharePoint Maven site also has a great article with pictures - How to make the Content Types available on all SharePoint Sites via the Content Type Gallery

 

I hope this helps.