When choosing a main category, it will show its all subcategory.

(1) Share

Report

Posted on by AR-23070103-0

I have made two table in Dataverse.

1 contain all the data and another contain main category and subcategories only. Take below table as a reference.

Name	Category	Subcategory
Niko	Animal	Cat
YAMAHA	Ride	Bike

Category	Subcategory
Animal	Cat
Animal	Dog
Ride	Bike
Ride	Car

While entering main category I want all the data for subcategory. in drop down.

Categories:

Building Power Apps

I have the same question (0)

All responses (2)

Answers (0)

Sort by

Michael E. Gernaey 53,978 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi

Let’s pretend you have a drop-down for main categories called MainDropdown

lets say you have another dropdown for sub category called Subdropdown

In the Items property of Subdropdown put

Filter(CategoryTalbleName, MainCategory = MainDropdown.Selected)

and now subcategory will only have the associated sub categories for the main selected

Was this reply helpful? Yes No
SoPatt Microsoft Employee on at

Like (1)

Report
Copy link

Link copied!
I'm assuming you want to do this in Power Apps based on where the question is posted.

I'm not quite clear on what you're asking. I think you're saying want to have category in one dropdown and then subcategory in another. Are you trying to generate items in the first table?

Assuming that, I'm calling the first table "ThingsInCategories" and the second table "Category_Subcategory". I created the below UI with two dropdowns, a text input, a button, and a gallery that shows all the items in ThingsInCategories.

For the Category dropdown (ddlCategory), here is the Items property:

Distinct(Category_Subcategory,Category)

For the Subcategory dropdown (ddlSubcategory), here is the Items property:

Filter(Category_Subcategory,Category=ddlCategory.SelectedText.Value)

For the Add button, here is the OnSelect property:
Patch(ThingsInCategories, Defaults(ThingsInCategories), { Name: txtName.Text, Category: ddlCategory.SelectedText.Value, Subcategory: ddlSubcategory.SelectedText.Value } )

Was this reply helpful? Yes No