Forum Discussion

laser132217's avatar
laser132217
Copper Contributor
Oct 31, 2022
Solved

Filtering in Lists - multiple values required

Hi,   I have a metadata column called ‘RENGEN Tags’ in a List that contains words and phrases that serve as tags to describe each item in the List. For example:   Item 1 ‘RENGEN Tags’ values: Ta...
Lists
microsoft lists
SharePoint Online
  • ganeshsanap's avatar
    ganeshsanap
    Nov 01, 2022

    laser132217 This is not possible using SharePoint default "Filter by" option as you are filtering on same field. 

    However, you can construct URL on your own like below: 

     

    https://contoso.sharepoint.com/sites/SPConnect/Lists/ChildList/AllItems.aspx?FilterField1=Scope&FilterValue1=A&FilterType1=MultiChoice&FilterField2=Scope&FilterValue2=B&FilterType2=MultiChoice

     

    This is filtering multiple selection Choice field based on value A AND B. Similarly, you can build URL for metadata fields. You might need to change FilterType as per the metadata field.

    Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

ganeshsanap's avatar
ganeshsanap
MVP
Nov 01, 2022

laser132217 Example for filters on multiple selection managed metadata column:

 

https://contoso.sharepoint.com/sites/SPConnect/Lists/ImageList/AllItems.aspx?FilterField1=DeptMetadata&FilterValue1=SharePoint&FilterType1=TaxonomyFieldTypeMulti&FilterField2=DeptMetadata&FilterValue2=M365&FilterType2=TaxonomyFieldTypeMulti

 

Please click Mark as Best Response & Like if my post helped you to solve your issue. This will help others to find the correct solution easily. It also closes the item. If the post was useful in other ways, please consider giving it Like.

Resources