Power Platform Community Forum Thread Details

Hi Experts

I have a sharepoint list named CategoryList, I have another sharepoint list named SubCategoryList (which looks at CategoryList as a source), I also have another sharepoint list named SubcategoryItemsList (which looks at SubCategoryList as a source). This allows me to filter my dropdowns based on the Category selected, then by the Subcategory selected and then again by the Item selected. E.g. Category selected is Hardware, Subcategory then only shows the subcategories that have been set in the sharepoint list for the category of Hardware and then the Items only shows the items that have been set in the sharepoint list for the subcategory.

Dropdown_Category
Items Property is:

Sort(
   ForAll(Distinct(
      CategoryList,
      Title
   ), {Result: ThisRecord.Value}),
   Result
)

What should the items property of Dropdown_SubCategory and Dropdown_Items be? I did have the below in Dropdown_SubCategory but then the Dropdown_Items didn't show the correct results:

Sort(
   Filter(
      SubCategoryList,
      Category.Value = Dropdown_Category.Selected.Result
   ),
   Title
)

Thanks in advance

Dave

Categories:

Building Power Apps

Community site session details

Category, Subcategory and Items Dropdown List

Helpful resources

News and Announcements

Quick Links

Forum hierarchy changes are complete!

Ajay Kumar Gannamaneni – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Power Apps

Featured topics

Product updates