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
)
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.