Look up function in SharePoint List

Question

Hi Guys:

I have a list like below in list A, then I have list B with a look up column, I will choose Product Family in the look up family, and I hope when I choose A, in other column, it will show 2 choices (A Black,A White), how can I get the function?

Product Family	Product Name
A	A Black
A	A White
B	B White
B	B Black
C	C Black

Answer 1

Dear respected YorkGA,

Good day! Thank you for posting to Microsoft Community. We are happy to help you.

As per your description, in SharePoint, you can create relationships between two lists using lookup columns. However, SharePoint's out-of-the-box lookup columns do not directly support conditional dropdowns (cascading dropdowns) which dynamically change the available options based on a previous selection (such as showing different choices based on the Product Family selected). Also, lookup columns don't support Choice (multi-valued).

We feel your pain due to this limitation and we’re really feel sorry for it. However, we appreciate your understanding.  I do understand the inconvenience and apologize for it.

Meanwhile, I believe Microsoft has been consistently modernizing various aspects of Microsoft SharePoint, and it's possible that may receive updates in the future.

Personally, I completely agree with you, this is indeed a good addition to the current features of Microsoft Office 365 application.

Meanwhile, as Microsoft get their attention is through the feedback mechanisms and Microsoft roll out feature requested from Microsoft 365 customers. I recommended you may also let your valuable Future request to Microsoft SharePoint product developer related Team through the feedback mechanisms.

We sincerely recommend you, regarding to your concern, I request you, please send your feedback and write down what you want them to implement via this link: Microsoft SharePoint feedback portal, Microsoft product developers team monitor this site 24/7 and they will receive your request and put it into consideration. This is the best platform to let related team hear from you and make the products and services better for you and others.

We can expect this feature to be used in the future.

I'm really sorry and I apologize for it.

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

Sincerely,

Waqas Muhammad

Answer 2

Dear YorkGA,

Good day!

Thank you for posting in 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,

Tina | Microsoft Community Moderator