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

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Users online (2,647)