Modern experience Filters pane for Multivalued Lookup column misbehaving

%3CLINGO-SUB%20id%3D%22lingo-sub-2115652%22%20slang%3D%22en-US%22%3EModern%20experience%20Filters%20pane%20for%20Multivalued%20Lookup%20column%20misbehaving%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2115652%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EWe%20have%20an%20Online%20(M365)%20SharePoint%2C%20Modern%20experience%2C%20hosting%20a%20Document%20Library%20%E2%80%9CDocLib%E2%80%9D%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Ewith%20a%20%5BCountries%5D%20multivalued%20lookup%20column%20targeting%20column%20%5BCountry%5D%20in%20a%20%E2%80%9CCountries%E2%80%9D%20List.%26nbsp%3BThis%20List%20also%20contains%20a%20%5BRegion%5D%20column%20which%20relates%20any%20country%20to%20a%20specific%20region%2C%26nbsp%3B%3C%2FSPAN%3E%3CSPAN%3Eand%20this%20column%20is%20%3CEM%3Eimported%3C%2FEM%3E%20in%20%E2%80%9CDocLib%E2%80%9D%20resulting%20in%20another%20column%2C%20%5BCountries%3ARegion%5D.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EAs%20%5BCountries%5D%20is%20multivalued%2C%20%5BCountries%3ARegion%5D%20appears%20to%20be%20multivalued%20as%20well.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EBut%20filtering%2C%20using%20the%20standard%20Filters%20pane%20behaves%20strangely%20on%20%5BCountries%3ARegion%5D.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EWe%20expected%20to%20be%20able%20to%20filter%20on%20any%20individual%20region%20a%20document%20can%20be%20relating%20to%20(through%20the%20countries%20the%20document%20is%20relating%20to).%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EHowever%2C%20here%20is%20what%20we%20get%3A%3C%2FSPAN%3E%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSPAN%3EInstead%20of%20individual%20%5BRegion%5D%20values%2C%20we%20get%2C%20in%20the%20Filters%20pane%2C%20individual%20%E2%80%9CSets%20of%20Regions%E2%80%9D%20resulting%20from%20all%20regions%20related%20to%20all%20countries%20in%20%5BCountries%5D%3CBR%20%2F%3Ebut%20there%20is%20more%E2%80%A6%3C%2FSPAN%3E%3C%2FLI%3E%3CUL%3E%3CLI%3E%3CSPAN%3ESelecting%20individual%20Regions%2C%26nbsp%3Bwork%20just%20as%20expected.%20In%20the%20picture%20you%20see%20Regions%20%E2%80%9CMiddle-East%E2%80%9D%20and%20%E2%80%9CAfrica%E2%80%9D%20selected%20and%20on%20the%20left%2C%26nbsp%3Byou%20can%20see%20that%20any%20document%20with%20at%20least%20one%20country%20belonging%20to%20these%20regions%20are%20displayed%3CBR%20%2F%3E%3C%2FSPAN%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22x.png%22%20style%3D%22width%3A%20498px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F252721iEF7CD140CD0664F6%2Fimage-dimensions%2F498x254%3Fv%3Dv2%22%20width%3D%22498%22%20height%3D%22254%22%20role%3D%22button%22%20title%3D%22x.png%22%20alt%3D%22x.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FUL%3E%3CUL%3E%3CUL%3E%3CLI%3E%3CSPAN%3EOn%20the%20other%20hand%20selecting%20%E2%80%9CMiddle-East%3B%20Middle-East%E2%80%9D%20in%20the%20Filters%20pane%2C%3CBR%20%2F%3Ewhich%20results%20from%20relating%20a%20document%20to%20both%20Oman%20and%20Saudi%20Arabia%20in%20my%20exemple%2C%3CBR%20%2F%3Egives%20no%20result%20at%20all%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22y.png%22%20style%3D%22width%3A%20479px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F252723iC16F6CCF1D6D0722%2Fimage-dimensions%2F479x212%3Fv%3Dv2%22%20width%3D%22479%22%20height%3D%22212%22%20role%3D%22button%22%20title%3D%22y.png%22%20alt%3D%22y.png%22%20%2F%3E%3C%2FSPAN%3E%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FUL%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EMy%20expectation%20would%20be%20%E2%80%93%3C%2FSPAN%3E%3C%2FP%3E%3CUL%3E%3CLI%3E%3CSPAN%3EHaving%20in%20the%20%5BCountries%3ARegion%5D%20Filters%20pane%20any%20individual%20distinct%20regions%20linked%20to%20the%20countries%20the%20documents%20in%20the%20view%20are%20relating%20to%3CBR%20%2F%3ETHIS%20IS%20NOT%20WORKING%3CBR%20%2F%3E%3C%2FSPAN%3E%3C%2FLI%3E%3CUL%3E%3CLI%3E%3CSPAN%3EAlso%2C%20No%20%22combinations%20of%20regions%22%20should%20appear%20in%20the%20pane%2C%20they%20do%20not%20work%20anyway%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3C%2FUL%3E%3CUL%3E%3CLI%3E%3CSPAN%3ESelecting%20the%20regions%20in%20the%20Filters%20pane%20would%20keep%20the%20documents%20that%20relates%20at%20least%20one%20of%20these%20selected%20regions%20-%26nbsp%3BTHIS%20IS%20WORKING%20JUST%20FINE%3CBR%20%2F%3EExcept%20that%20not%20all%20regions%20are%20displayed%20if%20not%20appearing%20individually%20and%20alone%20on%20any%20of%20the%20document%20of%20the%20view!%3C%2FSPAN%3E%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSPAN%3EIs%20this%20a%20bug%3F%20Did%20I%20miss%20something%3F%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2115652%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3Efilters%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ELookup%20Column%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2681563%22%20slang%3D%22en-US%22%3ERe%3A%20Modern%20experience%20Filters%20pane%20for%20Multivalued%20Lookup%20column%20misbehaving%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2681563%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F163596%22%20target%3D%22_blank%22%3E%40Pierre%20Hubaut%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3EHas%20this%20issue%20been%20solved%3F%26nbsp%3B%20I%20run%20into%20same%20problem%20with%20multivalued%20managed%20metadata%20column%20filtering.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThanks.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

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
      x.png
    • 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
      y.png

 

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?

2 Replies

@Pierre Hubaut 

Hi,

Has this issue been solved?  I run into same problem with multivalued managed metadata column filtering.

 

Thanks.

Not really.
In fact, I have several columns couple with similar hierarchies for my data:
- "Countries" and "Countries:Region" but also
- "Products" and "Products:Product Line"
for some reason (which I would like to understand), the problem disappeared on "Countries"/"Countries:Region" but the problem remains, for instance, on "Products"/"Products:Product Line" on my side.