web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Add item to List/Colle...

Power Apps

Answered

Add item to List/Collection?

(0) Share

Report

Report

Posted on by BrianHFASPS

732

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.

Categories:

Building Power Apps

All responses Img

All responses (1)

Answers Img

Answers (1)

Verified answer

BrianHFASPS 732 on at

Like
a
(0)

Report
Copy link

Link copied!
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?

Join the conversation