4/7/2020 10:15:00 PM

This is the Power Treasure Hunt App. A Power Apps Canvas app build to manage and facilitatie treasure hunts.

The app is build using only standard features of Canvas Apps. There are no connections to external data sources. The app uses Bing Maps to display sattelite imagery as clues to find waypoints.

It is simple to use and great fun for everyone.

Download it for free and use it as it is or customize it to your own liking

Click through to download the app and plan your next treasure hunt today!

4/6/2020 11:36:00 PM

When asked "What is Power Apps?" I often explain by saying "Imagine Power Point and Excel had a baby, that would be Power Apps. Visual design like Power Point and Low Code formulas like Excel to tie design and functionality together.".

However, one visual element that I use a lot in Power Point is still missing in Power Apps. That is the Gradient Fill element. However, in Power Apps we have the Power Apps Component Framework that allow creation of custom controls and visual elements that can be used in Power Apps. So, I have created a Gradient Fill control that fills some of the needs you might have for using gradient colors.

Read on for examples, video and downloads

4/4/2020 3:41:00 PM

Here is a Power Apps custom control to display text with a drop shadow. It can also be used to create an invisible text effect or a glow effect.

Among other you can configure color, font, shadow blur and size.

Also, give it a go in Canvas Apps, I'm sure you will find it fun and come up with some interesting effects.

Click through for video and download

4/2/2020 5:28:00 PM

It is best practice to indicate to the user of your app that your app is doing work that the user should wait for. A common way of doing this is using animated gifs that indicates that the app did not freeze but is doing background work.

In this blog post I will show you how to use the custom SpinningText control to create a dynamics spinner that allow you to display what ever text you want while the app is doing background work.

Click through to read how to make this yourself and link to download my example app
3/30/2020 3:00:00 PM

Power Apps already comes with many great controls out of the box. But still, sometimes you have a need that is not fulfilled with out-of-box functionality. Thanks to the pro developer extensibility of the platform we can create our own controls using the Power Apps Component Framework, PCF.

Here is a set of controls you can use to animate text in different ways

Click through for info, download and source code
3/22/2020 12:08:00 PM

There are several ways to get an Inventory status of your Power Platform Environments. There is the Center of Excellence Starter Kit, you can build your own using the Admin connectors, or, you can use the PowerShell admin modules as I have done here.

Using the PowerShell admin modules for Power Platform I have written a PowerShell script to download data regarding Power Platform Environments, Power Apps Canvas Apps and Power Automate Flows. The downloaded data is saved as csv files.

Click through for source code and download 

3/20/2020 4:47:00 PM

Today I did a live stream on how to build a Power Platform Youtube Library app using Power Apps Canvas App.

Recording of the live stream is here: Canvas App in 45 minutes - Recording

You can find all the formulas for the app as well

Click through for video and formulas and build the app yourself

3/13/2020 3:00:00 PM

When working with Common Data Service on the Power Platform you will eventually have requirements to execute multiple operations in single request. This can be done using the batch framework of both the .NET SDK and the Web API.


Here is a C# example of a console app that will execute a batch request to create two contact records and retrieve contacts based on a query

Read on for example and source code

3/12/2020 3:57:00 PM

When creating OptionSets in Common Data Service on PowerPlatform and Dynamics 365 CE there are limits to the number of labels you can add before your index finger goes numb from all the copy and paste action.

Why not just InsertOptionSetValue.exe <OptionSetLogicalName> <OptionValueStart> <File Path> <Organisation Connection String>

Here is an example of a console app that will create OptionSet labels based on a list in a csv file.

Read on for example and source code

3/1/2020 1:28:00 PM

As part of the blog series on using Power Platform as your Development Platform as a Service (DPaaS) here is the first blog post on how to authenticate your apps and services with Active Directory and Common Data Service

If you are looking to build apps or services that integrate with Power Platform and Common Data Service (CDS) you will of course have to authenticate your user(s) before being able to use any of the integration endpoints.

Authentication with Common Data Service is handled by Azure Active Directory and there are several options depending on your programming language and use case scenario.

This blog post discuss how to authenticate in both Server to Server and User scenarios with source code in JavaScript, Python and C#.

Read on for details on setting this up including sample code

2/25/2020 7:00:00 AM

I recently posted a slide to LinkedIn without much else than a couple of hashtags. The slide was from a presentation I was preparing for a customer and visualized a conceptual architecture for building apps on the Power Platform Common Data Service (CDS). The response from fellow LinkedIn users was overwhelming. Many asked for copies of the presentation.

However, the actual message of the presentation was not so much the slides but rather the 10+ demos that accompanied the slides.

This is why i decided to write a series of blog post discussing how CDS and Power Platform can be your Development Platform as a Service (DPaaS).

This is the first post in the series and I will use this to put some words on the different components of the mentioned conceptual architecture slide. In future posts I will address the demo scenarios of the presentation.

Read on to see how you can use Power Platform and CDS for Apps as your Development Platform

11/7/2019 1:49:00 PM
Rollup fields are a great feature of the PowerPlatform. Rollup fields are used to aggregate values of related records to give the user insights into data in the record relationships. They can be used to calculate the total amount of an order by aggregating the order line amounts using the SUM() function. Another common scenario is using the COUNT() function to count number of related records. This can also be done using hierachical relationships, ie. aggregate values from related records and their related records and their related records ...

You can imagine how much work is done behind the scenes in order to achieve the desired goal based on the simple configuration. It would require a lot of work to implement this functionality yourself.
However, as with most great things in life, there is a catch.
Rollup fields are only calculated every 12 hours via a recurring system job. The schedule of the job can be changed but the frequency cannot.
Users can manually force a recalculation of a Rollup field by clicking the Recalculate button below the rollup field.

Click through to learn how to create a Custom Connector to recalculate rollup fields on the fly
10/8/2019 8:59:00 PM

Here is an example of a PowerApps custom control build using Azure Maps to generate interactive maps of your data points.

Azure Maps is a service that allows for integration into custom applications. It allows you to add geospatial capabilities such as maps, search, routing, and traffic to your application. 

For the scenario in this post I used Azure Maps to identify locations of traffic cameras in Copenhagen, Denmark. Red cameras illustrate that there is an anomaly with the camera feed. When zoomed out the pins are clustered, a red outline indicates the cluster contains at least one camera with an anomaly.

Click through for video and source code
10/7/2019 11:00:00 PM
Had a conversation with colleagues today about the value propersition of the PowerPlatform from an app developer perspective.

You get a boat load of features and functionalities out of the box that you would otherwise have to build and manage your self.

On top of that you also get a myriad of ways to integrate with other systems applications. And DevOps tools to support your agile develoment methodology. And a global and helpful community

Read on for the list

10/6/2019 10:30:00 PM

Azure Application Insights Custom Events allow you to track events in your Canvas app. A Custom Event can be anything that happen in you PowerApp such as 'order submitted', time registration deleted', 'settings saved' or anything else you find meaningful to track.

Tracking these type of events gives you deep insights into how users use your app.

I wrote a blog post, Using Azure Application Insights to monitor your PowerApps Canvas App, about using a PCF control to implement Application Insights PageViews telemetry in your PowerApps Canvas app to track screens used. Using Custom Events can improve the feedback you get from your app and usage of it and make you better equipped to deliver value for your users.

Read this blog post to see how you can implement this cool feature in your own app.

10/2/2019 8:28:00 AM

Microsoft Flow has an RSS Feed action that can be used to retrieve news feeds from web site that implement RSS feeds.

On this blog I am aggregating feeds from a range of blog from the Dynamics 365 and PowerApps community. Find it here https://www.powerappsguy.com/news

The news aggregator also serves up a RSS feed that can be used to retrieve a feed of news from the community.

In the below example I will show how you can setup a simple Microsoft Flow to receive notifications when new blog posts are published.

9/25/2019 3:57:00 AM

The PowerPlatform offers monitoring of your apps on a high level. The telemetry gathered includes Performance, Usage and Errors aggregated on the environment level.

As of now, there is no official way to get detailed telemetry at the app level.

I decided to give it a shot to see if I could create a PCF control that could send telemetry to Azure Application Insights.

Here is my initial attempt. It supports tracking of Page Views i.e. Screen Views which includes screens views, duration, user information, session information, geographic information and other telemetry.

It's a custom PowerApps control for Canvas Apps. It might be useful for Model-Driven apps also, you let me know, ok?

7/25/2019 11:00:00 AM
If you are running your portal to host your blog like I am then you might want to get rid of some of the login options on the sign in page.
In my case, the only option for sign in that I want is Azure AD.

The available options on the sign in page are:
  • Local SignIn - this is using credentials stored in Common Data Service / CDS on a contact record
  • Register - this allows users to register a new user account (contact record) in CDS
  • Redeem invitation - this allows users to register using an invitation code generated in CDS and usually sent to user via email.
  • External SignIn - this options use Azure AD credentials for signing in to the portal.
7/23/2019 10:00:00 PM

The capability of creating Portals have arrived to the already powerful PowerApps platform! The Portal feature of PowerApps allows you to create a web portal based on data in Common Data Service or CDS. It allows access for anonymous users so can be used for any external facing scenario.

It’s still in preview though so not recommended for production scenarios.