Forum Discussion
Communication Site - Highlighted Content > Pages > Managed Property Empty
Unfortunately, you hit the limitation with that web part - no ability to do an AND connection with two different columns .... for now.
A small glimmer of usability I figured I had better report:
I mentioned that the Highlighted Content web part allowed an "AND" construction only if you used different types of filters ("Created By..." paired with "Content Contains...", for example). My problem was that when I switched the source of the HC to be "Page library on this site" I lost the "Content contains..." filter, and didn't see a way to use two filters of different type (of those that remained to me) in order to get that "AND" selection of the content that would show up.
I have now found that different Page Properties do create an "AND" selection. This means that if I add two columns from the Site Pages library (Category and Topic) for page properties, and for 3 pages I populate them as:
Page Name | Category | Topic |
Page 1 | info | encryption, malware |
Page 2 | action | malware |
Page 3 | info | bananas |
And then I set up a HC web part, I can configure the filters to produce the following results:
Filter 1 | Filter 2 | Pages Returned |
Category equals "info" | Page 1, Page 3 | |
Category equals "info" | Topic contains "malware" | Page 1 |
Category equals "action" | Page 2 | |
Category equals "action" | Topic contains "bananas" | <none> |
I have not tested with 3 filtered conditions, but my guess is that if they are filtering the same column, they would roll up into an "OR" union before being compared to the cross-column "AND" match.
Still, this bridges the use case I was having trouble putting into practice, so I will take it! Hopefully the info helps someone else, too.