UNIQUE Values From A Collection Column With A Blank At The Top

UNIQUE Values From A Collection Column With A Blank At The Top Input collection: myCities55 City Continent Country New York North America USA London Europe U...

Published: Published Jun 1, 2024
Reading time: 1 min read

Before you start

Is this guide for you?

Best entry point: Power Apps
Time investment: 1 min read

Open Power Apps Code hub Compare options

Imported reference from Matthew Devaney's blog for learning purposes. Original: https://www.matthewdevaney.com/powerapps-collections-cookbook/unique-values-from-a-collection-with-a-blank-at-the-top/. Author: Matthew Devaney.

UNIQUE Values From A Collection Column With A Blank At The Top Input collection: myCities55 City Continent Country New York North America USA London Europe United Kingdom Kyoto Asia Japan Osaka Asia Japan Los Angeles North America USA Paris Europe France Birmingham Europe United Kingdom

Output value: mySolution55 (unique Country names) Result blank USA United Kingdom Japan France Solution code: //Create a collection

ClearCollect(myCities55, { City : "New York" , Country : "USA" , Continent : "North America" }, { City : "London" , Country : "United Kingdom" , Continent : "Europe" }, { City : "Kyoto" , Country : "Japan" , Continent : "Asia" }, { City : "Osaka" , Country : "Japan" , Continent : "Asia" }, { City : "Los Angeles" , Country : "USA" , Continent : "North America" }, { City : "Paris" , Country : "France" , Continent : "Europe" }, { City : "Birmingham" , Country : "United Kingdom" , Continent : "Europe" } ); //Duplicate removal code

ClearCollect(mySolution55, { Result : Blank()}); Collect(mySolution55,Distinct(myCities55,Country)); Code language: JavaScript ( javascript )