MS lists advice - multi-level lists

Question

Hi, I have created a work tracker using MS Lists. This covers all of the work that my team are dealing with; reference numbers, dates, people, notes and more.

We need a way of filtering based on tags / keywords for future reference as there will be a lot of data. It is easy to do this as a single 'choice' column but there are too many categories to make this work effectively.

I need to break this down into subsections.

So I need to create a multi level list, or better still set it up so that when a category is selected in the first classification column, it will dictate what shows as the input options in the next column.

I have tried to do this using the 'make column visible if' function but I cannot make it work.

The column that I am trying to have as the initial (parent)? list is formatted as a choice, I think this is correct.

I'd be really grateful for advice on the easiest way of doing this as I am new to power apps etc. Thanks

Answer 1

Dear James,

Good day!!

I understand your concern and to my knowledge, the requirement you are looking for can be achieved by the dependent drop-down list but it can’t be possible via out of the box way in the SharePoint Online. However, you can achieve your requirement via integrating the List with the Power Apps.

So, I suggest you to post your concern in the Power Apps Community - Power Platform Community (microsoft.com) to get the detailed help from the experts.

Apologies for redirecting you to different community as the members in the category posted focus on the users with the Microsoft 365 concern and out of the box concerns on SharePoint Online, and have limited knowledge on the customization of Power Apps, to get the fast and better assistance, we have redirected you in the correct path.

Appreciate your patience and understanding. Have a great day!!

Best Regards,

Sophia

Answer 2

Dear user

Good day!

Thank you for posting to Microsoft Community. We are glad to assist. We are looking into your situation and we will update the thread shortly.

Appreciate your patience and understanding and thank you for your time and cooperation.

Sincerely.

Microsoft Community Moderator