Flow to Visio – XrmToolBox Addon
Sorry, the blog has been quiet, there is only so much time to spend on out of work activities, and this tool has been my time sink in the last 6 weeks. Not complaining, loved getting back to my routes. Documentation for many consultants is the worst part. Implementing stuff is fun, taking the same amount of time documenting what you have delivered is not. With this in mind, I created the
Accelerators: Nonprofit – Part 3 – Awards
This is the third post in the series looking at one of Microsoft’s Solution Accelerators, namely the Nonprofit version. This article will be discussing the Awards app. This app revolves around distributing funds to various projects and includes tracking of the associated programme delivery. I have already discussed installing and the Fundraising app in part 1 and the Constituents App in
Mockaroo Data Munger – XrmToolBox Addon
Another tool I am please to announce – Mockaroo Data Munger! This tool is an interface between Mockaroo and your CDS environment. Mockaroo is an excellent random data generator which has been my go to source for data over the last couple of years for building demo or test data sets. I found myself regularly configuring Mockaroo data exports, creating Excel spreadsheets and then importing… Continue Reading LinkeD365’s...
PL-100 – Microsoft Power Platform App Maker
One of the newest exams on the block is PL-100 Power Platform App Maker. This exam is targeted at individuals who are currently making apps for their company and want to certify their talents. I saw this exam similar to the MB-200 exam, which is soon to be replaced with PL-200, but I was wrong. The qualification associated with this exam is Power Platform App Maker Associate. The exam is… Continue Reading LinkeD365’s...
Accelerators: Nonprofit – Part 2 – Constituents
This is the second post in a series as a tool to educate me and document the functionality in the Microsoft Industry Accelerators. This post will dig a little deeper into the Nonprofit accelerator, with the second model app available to you, namely Installing and a guide to the Fundraising app can be found here TL;DR Walkthrough of the Constituents application which forms a central… Continue Reading LinkeD365’s Article on...
Accelerators: Nonprofit – part 1 – Fundraising
Microsoft Dynamics is a great set of tools, which cover a lot of the requirements for most situations. These Sales and Service tools tend to focus on a generic requirement rather than those that can be specific to an industry. To get a more specific version of the application, one that is more suited for an industry vertical, Microsoft provides several Accelerators. The accelerators are a… Continue Reading LinkeD365’s...
ERD Visio Builder – XrmToolBox addon
As with my Org Settings tool, creating Visio diagrams to represent and document your entities and relationships in Dynamics has long been on my list to find a better solution than making them yourself. There is already a couple of Entity visualisers in the XrmToolBox suite, but non that output to Visio. The project is available in XrmToolBox, source here and I am indebted to Saveen… Continue Reading LinkeD365’s Article on...
Adding to Calendars using Power Automate
D365 Customer Service and Field Service both use Calendars associated with resources to schedule working time. This is accessible via the resource calendar and typically relies on the individual working a set time frame each week. Fiona works Monday to Friday, 8-5. When you are working with volunteers, this doesn’t work. Each volunteer will have an inconsistent schedule, with most of the… Continue Reading ‘s Article...
D365 Org DB Settings – XrmToolBox addon
Regular readers (Hi Mum) will remember I have done several articles on Org DB Settings. I have got 2 pages in the top bar dedicated to a description of each setting, the first all about the various Email Settings you can tweak, the second covering the rest of them. Both articles continue to be readily used by people, assume looking for a better understanding, as the Microsoft documentation… Continue Reading ‘s Article on...
Approvals – Showing History in SharePoint
Last week, I took part in the Microsoft 365 Virtual Marathon. This was a branch out for me, as it wasn’t specifically Dynamics 365 or Power Platform related, though everything is one now right? My talk was around Approvals, displaying 3 types of approvals, from a Send with Options to Adaptive cards, topics I have covered in my blog before. During the sessions, one of the questions was… Continue Reading ‘s Article on...
Customer Service Insights
Following on my series of posts about Sales Insights, I thought I would learn more about Customer Service Insights. Sales Insights, in my view, is all around making the sales process more effective reducing the time spent editing data, highlighting activities that a sales user should be doing and tracking activity with your customer. Sales Insights includes forecasting and predictions as… Continue Reading ‘s Article on...
Using Power Automate to generate Data
Previously, I have used Mockaroo and Flow to generate data, but the data I required for demoing the Customer Services Insights functionality has to be linked from existing data to be valid. In this post, I will guide you through the methods I have used to randomise and create demonstration data that fits the requirements for Customer Service Insights, just using Power Automate and an… Continue Reading ‘s Article on their...
Sales Insights: Sales accelerator
This is the final of a 6 part series on Sales Insights, where I attempt to walk through of the Sales AI functionality that is part of the suite. The other articles are listed here. Basic (Free) Setup – The “free” AI capabilities that can be added to any Sales Instance Assistant Studio – Full capabilities – The full suite of options for Insight Cards Productivity Intelligence –… Continue...
Sales Insights: Predictive Models
This is the fifth in the series on Sales Insights, were I attempt to walkthrough the Sales AI functionality that is part of the suite. The other articles are listed here. Basic (Free) Setup – The “free” AI capabilities that can be added to any Sales Instance Assistant Studio – Full capabilities – The full suite of options for Insight Cards Productivity Intelligence – Activity and… Continue...
Launch (Self) – Check App permissions in Power Apps
On the Twitterverse yesterday, it was announced that you now have the ability to Launch an application to replace itself. Formulas: Launch to self and Self operator Some long awaited features for Power Apps canvas formulas! When run in a web browser, a canvas app can now replace itself with another canvas app or a web page. This has been a long running community ask and also came up when we were created the COVID-19 Hospital Emergency...
Mockaroo and Flow: Perfect Demo data
As a consultant, architect or just a blogger, you have to do a lot of demos. Recently, with my look at Sales Insights, the amount of data I needed was increasing. I had used Flow in the past to automate data entry, and it worked well, so I thought I would create some data for my environment using Flow, but first sourcing the data in Mockaroo. Mockaroo Mockaroo is a free data generator… Continue Reading ‘s Article on their...
Sales Insights: Connection Insights
This is the fourth in a series walking through the Sales Insights add-on application. The series list is below for your reference. Basic (Free) Setup – The “free” AI capabilities that can be added to any Sales Instance Assistant Studio – Full capabilities – The full suite of options for Insight Cards Productivity Intelligence – Activity and Contact suggestions as well as Notes… Continue...
Sales Insights: Productivity Intelligence
This is the third instalment of my review/walkthrough of the Dynamics 365 Sales Insights application. Part 1 detailed the free features, with Part 2 detail the first of the premium features, Assistant Studio, including custom Insight cards and how to prioritise them. This time, the blog is about Productivity Intelligence. This encompasses Auto capture (automatically bringing in content… Continue Reading LinkeD365’s Article...
Sales Insights: Assistant (full capabilities)
In my previous post, I walked through the configuration of the standard, “free” features of the Sales Insights offering for D365 Sales. This time, I am going to start on the premium features covered by the £37.70 per month license fee. If you look at the Sales Insights administration screen, the list of the capabilities is quite hefty. For this post, I will concentrate on the Assistant,… Continue Reading...
Sales Insights: Basic set up
I have been working for quite a while on Customer Insights, running workshops and generally getting to know it, but I realised that there is a multitude of products in the Insights suite, Customer Insights, Customer Service Insights, Product Insights, Marketing Insights and Sales Insights. These tools each have their own niche, and I don’t know them at all well. So I thought I would educate… Continue Reading...
MB-400: Power Apps + Dynamics 365 Developer Associate Exam
This week, I am on holiday, meant to be in Egypt watching the kids swim in the Red Sea, drinking as much beer as I can & getting pink. As this didn’t happen, I decided to fit in an exam instead. Why not get another qualification instead? MB-400, the new developer exam, was the one I was dreading, more so than MB-600 I did a couple of weeks back, as my hands-on development has really ground… Continue Reading...
Changing working habits – WFH isn’t easy
As a departure from my usual posts, I wanted to share my thoughts on coping during the biggest change to our professional life: COVID-19. Social distancing rules have meant that a lot more of us are having less social contact with our colleagues, family and friends. This leads to stress and anxiety, exhibited in numerous ways, and if not tackled, depression. Further, our professional… Continue Reading LinkeD365’s Article...
3 Minute Features: Episode 10: Keys
When I started this series, my intention was to create a series of videos to guide a user in the fundamentals of the Power Platform, starting with Entities and working my way through each of the parts. The trouble with video is that it takes a long while to edit and prepare. Each video was taking 4-6 hours to produce. This, I am well aware, is most likely down to my lack of skill, but it… Continue Reading LinkeD365’s...
MB-600 : Microsoft Power Apps + Dynamics 365 Solution Architect (beta)
Last week I sat the MB-600 exam, which for any aspiring Solution Architect in our world is the pinnacle qualification. Still in beta, so not sure how I got on, but thought I would share my thoughts while I still remember. As part of my learning, I create mindmaps, it helps me focus my understanding and is quicker for me to review later for last-minute cramming sessions. With the rest of… Continue Reading LinkeD365’s...
Quick Approvals – Send with Options
As I digitally transform the club I am involved with, stardiving.org I come across ways in Power Automate that are pretty useful. I have previously talked about Adaptive Cards for approvals and this works great, but only for internal use. Same with Approvals, they are perfect for what I wanted to achieve, but limited to internal users. Send Email with options is a great way of getting… Continue Reading LinkeD365’s Article...
Incident App (Part 2)
In the first part of this series, here I established an application I wrote to improve incident management at the club I am proud to chair. Requirements Centralised, secure list of incidents – (Part 1)Ability to add divers to list for trials or competitions (Part 1)Data entry must be easy and not time-consuming (Part 1)Weekly notification of all incidents to the welfare officerEmail to… Continue Reading Cooky’s...
Alexa, Field Service and Me (Part 5) – Using Azure Service Bus
In my previous post I walked through swapping out Power Automate with Azure Functions for responding to Alexa in our Field Service scenario. This post is about finalising the code by using Service Bus function to create the Work Order. In the Power Automate version I used a child flow call to allow the response to happen quickly, without waiting for the numerous calls to establish data… Continue Reading Cooky’s Article on...
Alexa, Field Service and Me (Part 4) – Using Azure Funtions
I was lucky enough to be given a speaking slot at Summit Europe in Barcelona on this Alex subject. Unfortunately this event is now postponed until June, but I set myself the challenge to replace the Flow in this solution with a more capable (quicker) response time. Power Automate is great, don’t get me wrong. I love that a low code alternative to connecting applications is available. I… Continue Reading Cooky’s...
Alexa, Field Service and Me (Part 4) – Using Azure Functions
I was lucky enough to be given a speaking slot at Summit Europe in Barcelona on this Alex subject. Unfortunately this event is now postponed until June, but I set myself the challenge to replace the Flow in this solution with a more capable (quicker) response time. Power Automate is great, don’t get me wrong. I love that a low code alternative to connecting applications is available. I… Continue Reading LinkeD365’s...
Scottish Summit – A Review
The extra day a year only comes around every 4 years and it seemed appropriate that a lot of the Power Platform community came together to celebrate in Glasgow. Scottish Summit 2020 was sponsored by Avanade and myself and several colleagues went along to enjoy the event, cement Avanade in the community, share our knowledge and learn from others. With over 1000 people descending on the… Continue Reading Cooky’s Article on...
3 Minute Feature : Episode 9 : Dashboards
A common staple of the Model driven app experience, my 9th video runs you through creating single and multi stream dashboards Episode 9 : Dashboards Transcript Dashboards have 2 variants, those that are connected to an entity and those that are not. An entity dashboard, called Single Stream previouly, are designed for support desk users or similarly focused indviduals. The… Continue Reading Cooky’s Article on their...
3 Minute Feature : Episode 8 : Charts
Charts in a model app are a great tool for customisers to visualise data Episode 8 : Charts Transcript Charts in D365 allow a visualisation of the data from a view. We discussed views earlier in the series so won’t go into that. Starting at the Entity in your solution, you navigate to charts, select Add Chart The new chart display comes up We will begin with a simple… Continue Reading Cooky’s Article on their blog 3...
Incident App (Part 1)
Most of you won’t know this, but to keep me busy (as if work, blogging, presenting & community isn’t enough) I am the chair of my local platform diving club, Star Diving. Give them a look at http://stardiving.org/ if you or your son or daughter want to learn a great sport that pushes you to control your body & keep fit. My youngest son is part of the Skills squad (very proud parent) and he… Continue Reading...
3 Minute Features : Episode 7 : Forms Pt2
This is the second part of the Forms feature, highlighting some useful tips & where to start when Business rules is not enough. Episode 7: Forms Pt2 Transcript With forms, if business rules don’t meet your requirements, you may have to resort to Javascript. These little code snippets allow you to do pretty much anything on a form that is not possible in business rules, but be… Continue Reading Cooky’s Article on...
2020 Release Wave 1: Improved Email
Part of the 2020 Wave 1 were some changes to the Email functionality, namely contextual email communication & Easier selection of email templates. I have already been through enabling the Wave 1 release here, so won’t do that again. Easier selection of Email templates Previously, in an email, you can select the Template box, and it just gives you a selection of the templates. < div...
2020 Release Wave 1 : Kanban board
On 3rd February, early access to the Kanban board for Opportunities was made available, and as an avid user of Kanban like boards, I thought I would give it a spin. Kanban is a method of visualising and planning activities by their status. In the standard model app you can apply a process to any record, having a step by step guide to your business process. < h2>Enabling the Wave 1 Early… Continue Reading Cooky’s Article...
3 Minute Features : Episode 6 : Forms Pt1
There is a lot you can do with forms in the Modal driven app, so this topic is split into two Episode 6: Forms Pt 1 Transcript In the solution, select our entity, then forms Select the main form. Once the form opens, you can see the fields I have already added. I am going to a new tab, then add sections. Sections allow you to add controls linked to the primary record. Each… Continue Reading Cooky’s Article on their blog 3...
3 Minute Features : Episode 5 : Views
In the fifth installment of this series, I look at views. How to design them and where they are used. Episode 5: Views Transcript Starting on the entity, go to Views This lists all the system views that are associated with our entity. These are generated when you create an entity. Some of them are normal, views that represent data to the user when they view lists. Some have… Continue Reading Cooky’s Article on their blog...
3 Minute Features : Episode 4 : Business Rules
Wearing ties is a rule that is just bonkers, and not allowing working from home. Thankfully those in CDS are a little more understandable. Welcome to the 4th video in the 3 minute feature series, on Business Rules Episode 3 : Business Rules Transcript Starting from the Entity, select Business Rules, Add Business Rule At the top is some tools which we will use later The… Continue Reading Cooky’s Article on their blog 3...
3 Minute Features : Episode 3: Relationships
Relationships are difficult, will she go out with you? Are you good enough? Does he want to propose? Those in CDS are a little less complicated, but only just. My next 3 minute feature tries to give you an understanding of relationships Episode 3: Relationships Transcript First, lets explain a relationship The simpliest relationship there is in the Common data service… Continue Reading Cooky’s Article on their blog 3...
3 Minute Features : Episode 2 : Fields
This is the 2nd installment of my 3 minute feature videos, going into detail about the different field types, how they appear on the interface and some other useful stuff. Episode 2: Fields Transcript Starting with the new entity I created last time, select new then field. This pops up a form to the right, which has a display name and field name for you to enter the detail…. Continue Reading Cooky’s Article on their blog 3...
3 Minute Features : Episode 1 : Entities
My hiatus from blogging is due to my lack of creativity around thinking about problems and how to solve them and this got me thinking about a ready source of material that which would give me a infinite number of things to write about. As I always want to learn, and envy those that do these things, rather than a blog, I have started a video series which does a show and tell on a subject, in… Continue Reading Cooky’s...
D365 Org DB Settings – Other
This is the second of a series where I try to document all the rarely used settings available to your Dynamics organisation to tweak the standard behaviour. If you want to tweak your settings, see my previous post, or if you want to use a canvas app, see this post. ActivityConvertDlgCampaignUnchecked Default ValueTrueTypeBooleanDescription Controls the default value of the Record… Continue Reading Cooky’s Article on their...
D365 Org DB Settings – Canvas App
On the back of one of my other posts on the D365 Org DB Settings I thought it would be good to re-imagine the method to update these settings in a Canvas app. The solution from Sean McNellis is great and has been a big influence on my design, including the settings xml is pretty much a copy. I am hoping that I give users a more visual experience and this is a starter for a bunch of D365 CE… Continue Reading Cooky’s Article...
IFTTT – Stopping Freezer melt
I have a problem, well my family has a problem. We can’t shut the freezer door. Regularly (once a month) our freezer would be left open just enough to defrost but not enough to sound the audible alarm, resulting in squishy food. Annoying. To combat this, I bought myself a Sonoff TH10 temperature sensor and configured this to send me an alert when it reached a certain temperature. The… Continue Reading Cooky’s Article...
D365 Org DB Settings – Email
On a client recently I helped deploy Microsoft D365 App for Outlook. Unfortunately, the behaviour requested by the client and the default behaviour of the Server Side synchronisation was not aligned. This led to long discussions with Microsoft about some of the DB Org Settings we could utilise to tweak the way SSS works. As I researched these settings and discussed with my colleagues and… Continue Reading Cooky’s Article...
MS Certifications – Sharing my Mind Maps
Over the last 15 months, I have completed 5 Microsoft certifications and have used various sources on the internet to get me through. My method of remembering facts relies on completing a mind map. This way, I note down the key points (key to me anyway) for a subject and link them together, serving as a quick refresher on the day but forces me to fill out my knowledge as I research the… Continue Reading Cooky’s Article on...
Cloning Flows: Location triggers for everyone
Sometimes ideas don’t work out. This is one of these times. But the reason I blog is to learn, expand my knowledge of the PowerPlatform, expand my knowledge of components outside of it. So, I figured I would blog about my failure, learning is learning. As I started testing the flow again, moving environments etc, it started working. I guess this is down to the location trigger being a work… Continue Reading Cooky’s...
AI Builder – Text AI
My blogging journey started with using LUIS, one of Microsoft’s Cognitive Services to automate case assignment. This blog goes into detail about how this all hung together, using a model defined in LUIS, calling the LUIS endpoint when a new cases are created and classifying the case, by the subject, with the result from the call. After my summer break (sorry, but family etc comes first) I… Continue Reading Cooky’s...
User Admin – Published App
After being asked on LinkedIn to publish both the apps that I built for the User Security Admin walk-through I have done so on Dynamics Communities Power Platform Bank Stand-Alone Security / User App The first one, which if you remember is a stand-alone application detailed here can be downloaded here