T

The Power Architect

Solutions for the Microsoft Power Platform.

Power Apps With Function

The Microsoft Power Apps With function is a powerful way to divide complex formulas into smaller pieces. It is useful when used within a ForAll, since we can’t set variables within a ForAll. Since the formula is contained, it is preferred over context variables created using UpdateContext or global variables created using Set. The syntax looks like this: With( { myValue1: //add some logic }, //Do something with the myValue1result ) You can also have nested With functio...
Read post

Azure App Registration for Select SharePoint Sites

This post explains how to create an Azure App Registration and configure it to provide your application access to only select SharePoint sites. The Azure App Registration provides your application the permissions it needs to various sources, in this example, SharePoint. This eliminates the need to run your application using a user account. In this specific example, rather than giving full control to all of SharePoint, we want our app to only have access to select SharePoint sites. We can use P...
Read post

Azure Web App authenticating to SharePoint with an App Registration and Certificate

The goal of this post is to explain (to my future self) how to create an ASP.NET C# application that uses an Azure App Registration configured with a Certificate to access a SharePoint site. The advantage to this approach is that your application can be granted permissions to SharePoint, Microsoft Graph, and other services using the App Registration rather than a specific user account. My application is ASP.NET V4.8 that is published to an Azure Web App. It talks to SharePoint to do various th...
Read post

Create a self-signed Certificate using PowerShell

Run the following PowerShell to create a self-signed certificate using Windows and PowerShell. Useful for creating certificates to use in Azure App Registrations. Open Windows PowerShell ISE as an administrator. Copy and paste the PowerShell below into the editor. Use the cd command to change to a directory of your choice where you want to save the certificate files. Execute the code. You will be prompted for several input parameters. CommonName: Give your certificate a name you will recogni...
Read post

Accessing your Power Apps Environment Variables

Environment Variables allow you to define values that can be changed between different environments. This is especially helpful when deploying a Solution between Dev, Testing, and Production environments. The Environment Variables act as a configuration for the solution that can be different in each environment. This is how we can access those variables from our canvas Power Apps. Add an Environment Variable to your Solution Browse to your Solution. Select New > More > Environment Varia...
Read post

Bypass the Power Apps consent dialog

How to use PowerShell to disable the consent dialog showing when a user opens Power Apps for the first time or when a new connection is added. Set Consent Bypass PowerShell can disable the consent dialog when the user opens the Power App for the first time or when a new connection is added. Set-ExecutionPolicy -ExecutionPolicy RemoteSigned -Force dir . | Unblock-File Install-Module -Name Microsoft.PowerApps.Administration.PowerShell Install-Module -Name Microsoft.PowerApps.PowerShell -AllowClo...
Read post

Auto-Scroll in a Power Apps Gallery

Let say we have a Gallery that has many items in it, and we want to automatically scroll to a specific item when the screen loads (or some other event). We can do this by setting the Default property in the Gallery. Update the Default property of your Gallery to something like the following: LookUp(colDemoCollection, Id = Value(Coalesce(txtSelectNumber.Text, 1))) The above formula uses a LookUp function that filters the colDemoCollection (the data source of the Gallery) for an ID (a column in ...
Read post

Check your Power Automate licenses

Microsoft has provided some PowerShell that allows admins to check their Power Platform environment for invalid Power Automate Licenses before it becomes an issue. Unlicensed Power Automate Flows will be turned off. Microsoft is enforcing licensing on all Power Automate flows. The flow owner will be notified if any of your flows do not meet licensing requirements. The flow will turn off if not compliant after x days. Read the FAQ for licensing details. Open PowerShell First, open PowerShell...
Read post