List of choice for one column based on another column

[Mahmud335]

Let's say I have two columns like the following where COLUMN B is a choice field:

COLUMN A	COLUMN B
Fruits	Apple
Fruits	Banana
Fruits	Berries
Fruits	Cantaloupe
Vegetables	Broccoli
Vegetables	Cauliflower
Vegetables	Cucumber
Vegetables	Zucchini
Vegetable	Beet
Grains	Barley
Grains	Rice
Grains	Millet
Grains	Corn

I want COLUMN B to show a list to choose from based on the value in COLUMN A, only Fruits or Vegetables or Grains but not all. How can I do this? I have no programming experience. I would prefer a solution (if any) without any coding.

Thanks in advance.

[#2 · Accepted solution]

@Mahmud335 You can use Power Apps to customize the list/library forms and perform cascading on choice column in SharePoint list. Check below reference for more information:

1. Cascading Dropdowns in Power Apps from SharePoint list 

---

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]

Thank you Ganesh, it was really helpful