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

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

7 options to store data in Azure with Microsoft Flow

When you create flows you could store data in SharePoint or in CDS and Microsoft Flow will give you easy actions to create new items. But what if you want to store data in Azure. There are quite a few different options possible. In this post I will compare the options. When you look at … Continue reading 7 options to store data in Azure with Microsoft Flow