Power Apps

Alphabetically sort Dataverse choice columns

Not so long ago, choices were called Options Sets in Common Data Service. Common Data Service is the old name for Dataverse. A few other terminologies were changed, for example an Entity is now called a Table. When you create a choice field from the Power Apps maker portal, you can provide values. Below you can see that the choices …

Read More

Cloud flows triggered from app in managed solution

This article is for Power Platform developers that have knowledge about managed/unmanaged solutions and ALM. Managed solutions are one of the most important components for proper application lifecycle management. Usually you create an unmanaged solution in a DEV environment and you import (manually or using Azure DevOps Build Tools) a managed solution into UAT/TEST and PROD environments. Cloud flows do …

Read More

Environment variables in Power Apps

This article requires some knowledge about Power Platform environments, solutions and ALM (Application Lifecycle Management). In the Power Platform, when you develop critical applications, the best practice is to do this using multiple environments. First you develop in an environment, for example “IT DEV”. When you’re ready to (let the business) test, you move to for example “IT UAT” or …

Read More

Data source environment variables within the Power Platform

A new feature has landed within the Power Platform: data source environment variables. They can be used in Power Apps as well in Power Automate. In this blogpost we will focus in Power Automate. Microsoft mentions in their blogpost that it doesn’t use a premium feature/license which is great news. When you’re developing some more advanced Power Platform solutions, you …

Read More

PowerApps bypass consent when opening app the first time

Sharing a Power App with a user gives the user the rights to run the Power App. Every user that runs the Power App for the first time, needs to allow some services (connectors) that the Power App connects with. This can occur when the app is ran from a SharePoint page or directly from the Power Apps portal. You …

Read More

PowerApps CountRows() to count rows in nested Dataverse table

Dataverse (for Teams) (old name is CDS) supports relationships between data. When you set up a data model, you can create nested tables. Let’s imagine that a parent table “Company” has a relationship with a “Project” table. The “Project” table has a relationship with a “Task” table. If you want to show how many “Project” rows a “Company” row has, …

Read More

Responsive Power Apps & converting from phone layout to tablet layout

power apps converter tablet layout

Power Apps created with a phone layout are very small when you open them in Teams, on a tablet or on your desktop. Microsoft is working on a container control to build responsive Power Apps but this is still experimental while I’m writing this blogpost. After the experimental phase, it will go to the preview phase and can be used …

Read More

Filter a Power Apps gallery with multiple dropdowns

power apps multiple filters gallery

In a Power Apps Canvas app, we want to filter items from a SharePoint list with multiple filter conditions. We have a gallery that is connected to a SharePoint list. The SP list contains sites with metadata that tells for which company and which department the site is. We want to filter the gallery items on company and on department. …

Read More

Limitations of Project Oakdale in Teams

project oakdale limitations

Project Oakdale opens the road to a new data layer and many new features that were not available yet. Until now, we had following choices to store the data of a Power App: SharePointSQL (Premium connector)CDS (Premium connector)… Previously, CDS was premium. With Project Oakdale, you can use some kind of light CDS that is included in most of the …

Read More

Power Automate and Project Oakdale in Teams

power automate cds new item record

In my previous blogpost about Power Apps and Project Oakdale, we learned how to create an app with a many-to-many relationship using the new light version of CDS that was introduced together with Project Oakdale. In that blogpost, we created some tables. One of them is the “Company” table. It can occur that a company does not exist in the …

Read More