SharePoint Server: When 1 option selected in a column, get the options from that first option

Question

SharePoint Server: When 1 option selected in a column, get the options from that first option

Charlie Martharper 545

Hi!

I need a library that contains full of files and different columns that will contain a lot of terms from metadatastorage.

The thing is, When column 1 gets option A, Column 2 should get values tied or linked from value A in column 1 and only see those results and not the others. Is that possible?

In the excel I can do that but in the SharePoint I dont really know where to do that and how to do it.

If its possible, could someone help me? Thank you so much.

That would be perfect because if I am not wrong, there is a limit of 15 metadata columns or choice columns.

Thats why I want to do this, because in the other way it will be a lot more than that. I must do that or leave them without some of the columns.

Is this possible in the SharePoint Online? Like more than 15 columns or the possibility to link the options from other columns to specific results into other columns?

0 comments

1 answer

Your answer

Answer 1

Hi @Charlie Martharper,

Based on your description, it sounds like you're looking for a cascading or dependent dropdown, where the available values in one column are filtered based on the selection made in another column.

SharePoint Online doesn't provide this behavior out of the box for standard Choice or Managed Metadata columns, and the available options may depend on how your library and columns are configured. One possible approach may involve using Lookup columns and additional customization with Power Apps, but the implementation details depend on your environment and requirements.

Since your question involves form customization and dependent dropdown behavior, you may get more targeted guidance from the Power Apps Community: Microsoft Power Platform Community Forum Thread

This forum is dedicated to Power Apps and SharePoint integrations, and it is actively monitored by Microsoft engineers, MVPs, and Power Platform professionals who are familiar with recent security changes and known platform limitations. You are more likely to receive confirmed guidance, workarounds, or information about known issues and roadmap updates there.

The reason for this redirection is that the Microsoft Q&A forum focuses mainly on general Microsoft 365 topics and has limited coverage for Power Apps–specific behaviors and regressions. The Power Platform Community is the best place to get timely and accurate insights for this type of issue, and your question may also help other users facing the same situation.

I’m truly sorry for any inconvenience this redirection may cause. My goal is to help you get the most accurate and helpful support possible, and in this case, the Power Platform Community is the most appropriate channel.

Thank you for your understanding. Have a nice day and stay healthy!

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