We have an Online (M365) SharePoint, Modern experience, hosting a Document Library “DocLib”, with a [Countries] multivalued lookup column targeting column [Country] in a “Countries” List. This List also contains a [Region] column which relates any country to a specific region, and this column is imported in “DocLib” resulting in another column, [Countries:Region].
As [Countries] is multivalued, [Countries:Region] appears to be multivalued as well.
But filtering, using the standard Filters pane behaves strangely on [Countries:Region].
We expected to be able to filter on any individual region a document can be relating to (through the countries the document is relating to).
However, here is what we get:
- Instead of individual [Region] values, we get, in the Filters pane, individual “Sets of Regions” resulting from all regions related to all countries in [Countries]
but there is more… - Selecting individual Regions, work just as expected. In the picture you see Regions “Middle-East” and “Africa” selected and on the left, you can see that any document with at least one country belonging to these regions are displayed
- On the other hand selecting “Middle-East; Middle-East” in the Filters pane,
which results from relating a document to both Oman and Saudi Arabia in my exemple,
gives no result at all
My expectation would be –
- Having in the [Countries:Region] Filters pane any individual distinct regions linked to the countries the documents in the view are relating to
THIS IS NOT WORKING - Also, No "combinations of regions" should appear in the pane, they do not work anyway
- Selecting the regions in the Filters pane would keep the documents that relates at least one of these selected regions - THIS IS WORKING JUST FINE
Except that not all regions are displayed if not appearing individually and alone on any of the document of the view!
Is this a bug? Did I miss something?
