cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

All option in DropDown Filter

Hi everyOne,

I was trying to add "AllItems" to my dropdown but I already used a distinct function to have all the possible values in a column from sharepoint list (datasource):smileyfrustrated:

So do you have any idea how can i reformulate it to get "All" option + disctincts values

Thanks Smiley Happy

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

Re: All option in DropDown Filter

Hi,

it works for me like that ,

ClearCollect(Cntr, {Result:"All"});Collect(Cntr,Distinct('RR List',Country_x0020__x0028_list_x0020_))

Thanks for your help Smiley Happy Smiley Wink

View solution in original post

3 REPLIES 3
PowerApps Staff LanceDelano
PowerApps Staff

Re: All option in DropDown Filter

Have you tried adding your distinct data into a collection, you should be able to use "Collect" to add the item "All" to your collection.

Anonymous
Not applicable

Re: All option in DropDown Filter

No, actually im still new on PowerApps Smiley Wink

Thanks for your reply @LanceDelano  

Anonymous
Not applicable

Re: All option in DropDown Filter

Hi,

it works for me like that ,

ClearCollect(Cntr, {Result:"All"});Collect(Cntr,Distinct('RR List',Country_x0020__x0028_list_x0020_))

Thanks for your help Smiley Happy Smiley Wink

View solution in original post

Helpful resources

Announcements
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 273 members 5,230 guests
Recent signins:
Please welcome our newest community members: