Showing results for 
Search instead for 
Did you mean: 
Helper III
Helper III

Distinct Filter

I ma new to Powerapps and attempting to learn the basics here. I am developing my first app and my datasource is an excel spreadsheet. I have 3 screens in my app, the first is a splash screen with an enter button, the second is a list box that displays the contents of the first column called Location. The locations that I am using are 6 numerical characters long i.e. 020128. There are other records that are not. I created a formula that filters out the ones I don't need, however what's left there can be more than 1 of. therefore I need a distinct list. The code below works to filter, but how do I make it distinct as well?


Filter(Table1,Mid(Location,4,1)<>" ",Mid(Location,4,1)<>"-")

Frequent Visitor

Thank you so much for the explanation, it resolved my issue. 

The fact that you made the red parts clear which were new additions was essential. Very helpful, thank you so much !

@mr-dang Found another issue for large Lists in SharePoint... you are limited to the Max View Size (5,000 records) even if you fix your Filter successfully delegates the query to SharePoint. You need to filter down to 5k or fewer results before you can perform a Distinct function and ensure you get all values.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Users online (2,625)