Forum Discussion

Iron Contributor

Sep 21, 2018

Modern Experience: Highlighted Content - filter for two "and" connected managed properties

Modern Experience sites provide the "Highlighted Content" web part for dynamically filtering content. Filtering works like this: Title contains: project AND Created by is: John Doe ...

Brass Contributor

Sep 22, 2018

Hi,

The OR statements invalidates all previous filters in the view. Try the following:

Managed Property PercentageComplete contains: 100

AND

Title contains: project

AND

Created by is: John Doe

Managed Property AssignedTo contains: [ME]

AND

Title contains: project

AND

Created by is: John Doe

AND

Edit: Just as a note, I think [ME] evaluates to a user object or user id so if your AssignedTo field is a managed metadata column I don´t think you will get any results as they will never be equal.

PhilFancyAndMe
Iron Contributor
Sep 25, 2018
Hi Frank,

sadly I cannot set any "AND" or "OR" in this filter. The "AND" or "OR" is set by SharePoint Online itself.
If three different filters are used they will be connected with "AND". If one filter is used several times is values are connected with "OR" and this filter is connected with "AND" to other filters. See picture below.

Problem is that if you choose "Managed property" filter twice. One for the property "AssignedTo" and once for the property "PercentageComplete" both filters will be automatically set to be "OR" connected as it is the same filter (in SharePoint's eyes).