Create certificate for Azure AD app only permissions

If you are creating an Azure AD app with app only permissions, or a so called deamon app, you need to use a certificate. One option would be to create a self signed certificate. In most blog posts they use the deprecated makecert tool. If you haven’t used this before, it can be a bit hard to come by.

The alternative is to use PowerShell commandlets. So far I’ve seen some samples but not one complete script that does it all. Here I would like to share the script I use:

After you’ve run the script, you can copy paste the results in your Azure AD manifest files.

Using Dynamics 365 CRM lookups and alternate keys in Microsoft Flow

I’ve written a blog a while ago on using alternate keys with the Dynamics 365 / CRM WebApi. You can read the blog here. The post guides you in creating an alternate key and identifies some usage scenario’s.

Lately I’ve been working on an integration between Eventbrite and Dynamics 365 / CRM with Microsoft Flow. Currently I’m going back and forth between enthusiasm and disappointment. Sometimes it does more than you would expect and sometimes you’re missing the details you are looking for.


Most often you would want to set a lookup value in a record you are creating and updating. With flow this might be a bit hard as looping is cumbersome, or even impossible, to implement (e.g. nested loops are not supported).

The first thing you could do it set hard coded values. E.g. when creating a product in CRM it’s sometimes feasible to hard code the unit of measure. Simply pasting in the Guids works fine in such case:

Alternate key

Other time you want want to set a lookup to a record you are also integrating. E.g. with Evenbrite you have the ‘entity’ Events that I integrate with a custom entity Events. Event tickets I’m integrating with a custom entity Event tickets. On that event ticket entity I need to set the lookup to the related event. One option would be query for the event in CRM using Flow and setting the value.

However, to simplify things, I’ve created an alternate key on the Event entity in CRM, using the EventId from Eventbrite. Now setting the lookup is fairly easy, and we don’t have to query CRM to fetch the record. This sample works perfectly:


For now, Microsoft Flow seems to be a perfect tool to do lightweight integration scenario’s. Using alternate keys might really help in making your life a little easier in extending the options you have with Microsoft Flow.

Creating animated gifs

Sometimes you find tools that you would have love to have had earlier. One of those tools is ScreenToGif. It’s an open source and free tool to record your screen, webcam or sketchboard and save it as an animated gif.

I found it because I was looking for a tool like this to create animated gifs for my blog. But now I use it quite often in training materials and manuals. It’s super easy to create an animated gif and embed it in any web page or PowerPoint presentation.

Some of the things to be enthusiastic about:

  • You can snap the tool to the part you want to record. E.g. when I want to record a part of the browser, I simply click and hold the button and drag to the part you want to record. And it has some great intelligence on what part it should snap to.
  • You can easily change the frame rate of the recording
  • It receives regular updates

And you can even run it twice, so I could create this animated gif to show you how to use it: