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)<>"-")
Solved! Go to Solution.
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.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
User | Count |
---|---|
170 | |
94 | |
64 | |
63 | |
60 |
User | Count |
---|---|
243 | |
163 | |
94 | |
84 | |
82 |