Get Distinct List of items

De-duplicate your collections in PowerApps

When you have a large array of data and and the data has duplicates, it can be difficult to to de-duplicate your data in PowerApps. There is a Distinct function which returns a unique list of values however that only works on a single field. So that is great for filling drop downs but not … Continue reading De-duplicate your collections in PowerApps

Advertisements
No sort function

Sort an array or collection in Microsoft Flow

Have you ever tried to sort an array or collection in Microsoft Flow? Did you ever look for the Sort function when you build your expressions? You can stop searching! It doesn't exist. The Sort Azure Function You could however create an Azure function. Only recently the option to create Powershell v2 functions Apps can … Continue reading Sort an array or collection in Microsoft Flow

Table with unique items using the distinct function

PowerApps – Get your unique items listed in a gallery

The basic Distinct function usage In this post I'm looking at creating unique values within a gallery in PowerApps. I started by creating a Gallery with a list of items by feeding the gallery with some json containing some titles set to numbers. The labels control that I'm using is set to thisItem.Value.Title and this … Continue reading PowerApps – Get your unique items listed in a gallery