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 (Last 30 Days)
Users online (4,841)