Power Apps

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

Canvas Power App many-to-many relationships in Teams project Oakdale

power apps many to many relationship

Since you can make Power Apps in Microsoft Teams, you can also use a light version of CDS for free. With this light version of CDS, we can use a relational database that supports complex relationships between entities (tables). With SharePoint as a data layer, we can only do lookups to create 1-1 or 1-N relationships. Now that we have …

Read More

Displaying a multiple choice column in Power Apps

power apps show multiple choice column

Do you have a SharePoint list with multiple choice columns that you want to use in Power Apps or you get following error: “This formula uses scope, which is not presently supported for evaluation”? Let’s try to show the multiple choice column in your Power App. We start with an example. We have an expense “Business travel to France” with …

Read More