I have one dropdown that I use to filter a list in a second dropdown. This is my code:
Distinct(Filter('[dbo].[StuListSmall]',Grade='Covid Grade Dropdown_1'.SelectedText.Value),Section)
I want to add an option to top of list that is 'All'. I am sure there is some easy way to do this but I can't figure it out. I would prefer not to have to make a collection since with this it is cleaner and more dynamic. Thanks.
Solved! Go to Solution.
So my fix was in first dropdown in OnChange I put this in:
ClearCollect(SectionList, {Result:"All"});Collect(SectionList,Distinct(Filter('[dbo].[StuListSmall]',Grade='Covid Grade Dropdown_1'.SelectedText.Value),Section))
Then my second dropdown just references the SectionList collection. I guess that is the way to do it?
So my fix was in first dropdown in OnChange I put this in:
ClearCollect(SectionList, {Result:"All"});Collect(SectionList,Distinct(Filter('[dbo].[StuListSmall]',Grade='Covid Grade Dropdown_1'.SelectedText.Value),Section))
Then my second dropdown just references the SectionList collection. I guess that is the way to do it?
Stay up tp date on the latest blogs and activities in the community News & Announcements.
Dive into the Power Platform stack with hands-on sessions and labs, virtually delivered to you by experts and community leaders.
User | Count |
---|---|
201 | |
175 | |
61 | |
32 | |
30 |
User | Count |
---|---|
307 | |
263 | |
105 | |
79 | |
56 |