How to Implement Conditional Tag Filtering in SharePoint Document Library when you have different column with multitag??

Question

Hi everyone,

I have a document library in a SharePoint Online (It is a communication Site) containing around 1500 PDF documents, with four multi-tags columns, each having around 30 tags and each documents have an average of 2/3 tags for column ( i will attach a screen to make it more understandable).

I need to implement a conditional filtering system, where the options in one tag column are filtered based on the selection made in another tag column ( I want that tags in column 2,3,4... that have zero correspondence with the selected/filtered tag in column 1 disappear when you are going to filter the column 2...). This filtering system is important for people who are going to visit this communication site, because they should find in a very smart way the exact document they need.

I understand that Power Apps can be used to customize forms in SharePoint lists, but I am working with a document library, not a list. From what I've gathered, Power Apps might not allow direct customization of the document library's forms the same way it does with lists.

Here's what I'm trying to achieve:

• When a user selects a tag in Column 1, the options available in Column 2-3-4... should be filtered based on that selection in that way the tag that you can pin filtering the documents are less and less.

Given the constraints of working with a document library, I'm wondering:

Is there a way to implement this conditional filtering directly within the document library without creating a separate Power App?

Are there any workarounds or alternative methods using SharePoint features, JavaScript, or Power Automate to achieve this?

1. If not, what would be the best approach to implement such functionality in SharePoint Online? I need to do that for the company in a fast and smart way, please help me!

Any guidance or suggestions would be greatly appreciated! Thank you in advance :)

Answer 1

I do lots of test, currently, there is no option to set conditional filter in the multi-tag columns.

SharePoint OOTB features only support filtering a single column, not filtering corresponding columns.

JavaScript cannot be used in the modern experience in the SharePoint online.

Power Automate can change column value, but not can change document library view.

As a workaround, first use Export to excel, then try to set conditional filter in the excel.

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.