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:

Tag A, Tag B, Tag C

 

Item 2 ‘RENGEN Tags’ values:

Tag A, Tag E, Tag F

 

Item 3 ‘RENGEN Tags’ values:

Tag A, Tag C, Tag G

 

I would like to be able to use the filter function to show a list of cases that have all tags specified. For example, show all cases with Tag A AND Tag C. In this case it would show Items 1 and 3. 

At the moment however using the column filter function and ticking the boxes next to the individual tags shows cases with Tag A OR Tag C, which is not what I want. 

Is there any way to change this behaviour, ideally within the standard Lists functionality, although I do have some experience with Power Automate. 

thanks

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.

3 Replies

Sort By
  • 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.

  • ganeshsanap's avatar
    ganeshsanap
    MVP
    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.

Resources