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

create a hidden list

Create a hidden list in SharePoint Online

Today at the user group meeting one of the attendees had a nice idea to hide data in a list from the SharePoint interface. He created one list item with a title "You should not be here". Then he made that item the only visible item in the default view. The he made the list … Continue reading Create a hidden list in SharePoint Online