Skip to main content

Notifications

Power Apps - Building Power Apps
Unanswered

Category, Subcategory and Items Dropdown List

(0) ShareShare
ReportReport
Posted on by 24
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

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,691

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 65,019

Leaderboard