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

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
Power Apps
Power Apps

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

No, actually im still new on PowerApps Smiley Wink

Thanks for your reply @LanceDelano  

Anonymous
Not applicable

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
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (15,223)