FetchXML Builder July 2020 Release
With the July 2020 release of FetchXML Builder for XrmToolBox the new Column Comparison feature of the FetchXML language is supported. Read more about all new features and fixes below. New Features Column Comparison This feature of FetchXML got a lot of buzz from the community when it was announced by Microsoft on 2020-07-14. Thanks to contributions from fellow tool… Continue Reading Jonas Rapp’s Article on their blog...
New website launched: fetchxmlbuilder.com
Any tool worth its salt deserves a dedicated website. Six years after initial release, FetchXML Builder for XrmToolBox finally has its own home on the Internet. Under the domain fetchxmlbuilder.com you will find feature descriptions, tips, how-tos, and a forum dedicated to questions and ideas around FetchXML Builder. Of course there are also instructions on how to become an official… Continue Reading Jonas Rapp’s Article...
WordPress Header Anchor Links – YouTube
Step by step instruction on how to easily add anchor links to headers in WordPress pages and posts. source
Querying date intervals in the Common Data Service
Querying date intervals in Microsoft Common Data Service, Power Apps and Dynamics 365 is not always possible using Advanced Find nor is it as easy as working with plain SQL. TL;DR – with FetchXML this is quite possible! Have you ever wanted to tell your CRM (CDS, D365 etc.) things like: Show me all opportunities with Estimated Close Date exactly 90 days from now! Well, today a… Continue Reading Jonas Rapp’s Article...
Git Submodules in Visual Studio part 3 – Including the shared project and committing the changes – YouTube
This video is part of a series describing how to use git submodules for a C# Visual Studio project, the example focused on a plugin for Microsoft Dynamics 365 and Common Data Service, but the principles displayed are of course relevant to other project and repository types. Full article available at: https://jonasr.app/vs-git-subm source
Git Submodules in Visual Studio part 9 – Tracking changes in remote repository – YouTube
This video is part of a series describing how to use git submodules for a C# Visual Studio project, the example focused on a plugin for Microsoft Dynamics 365 and Common Data Service, but the principles displayed are of course relevant to other project and repository types. Full article available at: https://jonasr.app/vs-git-subm source
Git Submodules in Visual Studio part 2 – Adding the submodule to my solution – YouTube
This video is part of a series describing how to use git submodules for a C# Visual Studio project, the example focused on a plugin for Microsoft Dynamics 365 and Common Data Service, but the principles displayed are of course relevant to other project and repository types. Full article available at: https://jonasr.app/vs-git-subm source
Git Submodules in Visual Studio part 5 – Improving the submodule shared project – YouTube
This video is part of a series describing how to use git submodules for a C# Visual Studio project, the example focused on a plugin for Microsoft Dynamics 365 and Common Data Service, but the principles displayed are of course relevant to other project and repository types. Full article available at: https://jonasr.app/vs-git-subm source
Git Submodules in Visual Studio part 7 – Updating submodule the wrong way – YouTube
This video is part of a series describing how to use git submodules for a C# Visual Studio project, the example focused on a plugin for Microsoft Dynamics 365 … source
Git Submodules in Visual Studio part 1 – My project and the helper repository – YouTube
This video is part of a series describing how to use git submodules for a C# Visual Studio project, the example focused on a plugin for Microsoft Dynamics 365 and Common Data Service, but the principles displayed are of course relevant to other project and repository types. Full article available at: https://jonasr.app/vs-git-subm source
Git Submodules in Visual Studio part 8 – Reference latest version of submodule repository – YouTube
This video is part of a series describing how to use git submodules for a C# Visual Studio project, the example focused on a plugin for Microsoft Dynamics 365 and Common Data Service, but the principles displayed are of course relevant to other project and repository types. Full article available at: https://jonasr.app/vs-git-subm source
Git Submodules in Visual Studio part 6 – Committing submodule file changes – YouTube
This video is part of a series describing how to use git submodules for a C# Visual Studio project, the example focused on a plugin for Microsoft Dynamics 365 and Common Data Service, but the principles displayed are of course relevant to other project and repository types. Full article available at: https://jonasr.app/vs-git-subm source
Git Submodules in Visual Studio part 4 – Consuming the goodies of the submodule shared project – YouTube
This video is part of a series describing how to use git submodules for a C# Visual Studio project, the example focused on a plugin for Microsoft Dynamics 365 and Common Data Service, but the principles displayed are of course relevant to other project and repository types. Full article available at: https://jonasr.app/vs-git-subm source
Git Submodules in Visual Studio – YouTube
This video describes how to use git submodules for a C# Visual Studio project, the example focused on a plugin for Microsoft Dynamics 365 and Common Data Service, but the principles displayed are of course relevant to other project and repository types. Full article available at: https://jonasr.app/vs-git-subm source
Git Submodules in Visual Studio
Ever since I started working with development, I have both created and consumed libraries, frameworks, utilities and snippets to simplify and streamline my code. The methods to include this code have varied a lot; from simply copy-pasting code to linked files to private NuGet servers with build automation, full CI/CD etc. Lately I have started working with Git Submodules, and I struggled a… Continue Reading Jonas Rapp’s...
Conditional Unique Auto Number Sequences in Microsoft Dynamics 365 / CRM
A common request for Auto Numbers in Microsoft Dynamics 365 (CDS/CRM) is to have one number field with different formats and unique sequences based on data on the record or it’s parents.I call this “Conditional Unique Auto Number Sequences”. Click image to see original post. In a previous article I demonstrated one way of including dynamic information in a numbered attribute using a… Continue Reading Jonas...
NEW Release: UML Diagram Generator
Read all about the UML Diagram Generator tool that generates PlantUML files from your Microsoft Dynamics 365 / Common Data Service metadata: jonasr.app/UML The post NEW Release: UML Diagram Generator appeared first on The Dynamics 365 Trenches. Continue Reading Jonas Rapp’s Article on their blog NEW Release: UML Diagram Generator ⋆ The Dynamics 365 Trenches The UML Diagram Generator for XrmToolBox is a new tool that generates...
NEW Release: Power Apps Checker for XrmToolBox
Read all about this new tool utilizing the Power Apps Checker API here: https://powerappschecker.com The post NEW Release: Power Apps Checker for XrmToolBox appeared first on The Dynamics 365… Continue Reading Jonas Rapp’s Article on their blog NEW Release: Power Apps Checker for XrmToolBox ⋆ The Dynamics 365 Trenches Read all about this new tool utilizing the Power Apps Checker API here: https://powerappschecker.com Blog...
Power Apps Checker for XrmToolBox – YouTube
Read more: https://powerappschecker.com/ source
Create view: Active Contacts in My State
Microsoft Dynamics 365 Customer Engagement and Common Data Service offer us the querying language FetchXML to retrieve data. Since this is the language used for views saved in the system, we can use FetchXML Builder for XrmToolBox to alter the features of views beyond what is possible using platform features, without making them unsupported. I recently got a question from Mike if it would… Continue Reading Jonas Rapp’s...
Balancing Cool Tech, Usability and TCO
I’m a techie. I like new, shiny, cool stuff.Newest however, usually costs.And customers usually like cheap.Users don’t care about either.They just want a system that empowers more than it obstructs.So how do you find the balance between the three? Is it even possible? Or is it just another Project Management Triangle? Unfortunately, I don’t think there is a secret formula to solve the… Continue Reading Jonas...
No more Export as Unmanaged
Ever since “CRM 2011” Microsoft has been pushing the message that we should have unmanaged solutions only in Development environments. That message is being emphasized even more as we walk into the new Power Platform era.Ideas have been raised that one day we might not be allowed to import unmanaged solutions to an environment that is not explicitly tagged for Development. I would suggest… Continue Reading Jonas...
No more Export as Unmanaged ⋆ The Dynamics 365 Trenches
Ever since “CRM 2011” Microsoft has been pushing the message that we should have unmanaged solutions only in Development environments. That message is being emphasized even more as we walk into the new Power Platform era.Ideas have been raised that one day we might not be allowed to import unmanaged solutions to an environment that is not explicitly tagged for Development. I would… Continue Reading Jonas Rapp’s Article on...
The Milliseconds Are Here! ⋆ The Dynamics 365 Trenches
Ever since I started using the Plugin Trace Log for investigation of my plugins around three years ago, I have wondered why we don’t have timestamps with better granularity than seconds.As I expressed it in an article from 2017: Given the CPU power we have today, it is just incomprehensible why we should not get more detail in the timing of plugin execution.It is like defining my age… Continue Reading Jonas Rapp’s Article...
The Milliseconds Are Here!
Ever since I started using the Plugin Trace Log for investigation of my plugins around three years ago, I have wondered why we don’t have timestamps with better granularity than seconds.As I expressed it in an article from 2017: Given the CPU power we have today, it is just incomprehensible why we should not get more detail in the timing of plugin execution.It is like defining my age by… Continue Reading Jonas Rapp’s...
Easter week in the media
As the Easter approaches, this is a short week at work.Nevertheless, a lot has happened around the media. Here’s a recap. Press release On Monday I started my new job at CRM-Konsulterna, an infinitesimal Dynamics consultancy (compared to Avanade that I just came from) started by fellow MVP Gustaf Westerlund. My signing was highlighted in Swedish media through this press… Continue Reading Jonas Rapp’s Article on their...
Easter week in the media ⋆ The Dynamics 365 Trenches
As the Easter approaches, this is a short week at work.Nevertheless, a lot has happened around the media. Here’s a recap. Press release On Monday I started my new job at CRM-Konsulterna, an infinitesimal Dynamics consultancy (compared to Avanade that I just came from) started by fellow MVP Gustaf Westerlund. My signing was highlighted in Swedish media through this press… Continue Reading Jonas Rapp’s Article on their...
Avoid nested conditionals in Microsoft Flow by using Guard Conditions
After working as a developer for a quarter century I have seen my fair share of nested conditionals and probably caused way beyond my fair share.Nested conditionals make the code harder to read and simply less aesthetic. When working with Microsoft Flow, this becomes even more obvious with the screen real estate that the Flow designed requires. An alternative design pattern is to use
Avoid nested conditionals in Microsoft Flow by using Guard Conditions ⋆ The Dynamics 365 Trenches
After working as a developer for a quarter century I have seen my fair share of nested conditionals and probably caused way beyond my fair share.Nested conditionals make the code harder to read and simply less aesthetic. When working with Microsoft Flow, this becomes even more obvious with the screen real estate that the Flow designed requires. An alternative design pattern is to use… Continue Reading Jonas Rapp’s Article...
Dynamic content in Auto Numbers for Microsoft Dynamics 365 / CRM
As the creator of the Auto Number Manager tool in XrmToolBox, I get two questions more than any other questions: How can I number existing records?How can I add dynamic content to the numbers? In a previous article I gave my solution to the first question. I will now dive into the second one and show a simple way of adding dynamic information from the numbered entity and related entities… Continue Reading Jonas...
We create XrmToolBox tools at Dynamics 365 Saturdays!
The community of developers for Microsoft Dynamics 365 / CRM in general and for XrmToolBox in particular is a great bunch of people. But I wish there were more of us – the more the merrier The D365 Saturday phenomenon with pro bono speakers at a full day event, free of charge for participants, has spread like wildfire over the last couple of years.The connection to the XrmToolBox is… Continue Reading Jonas Rapp’s...
Auto Numbering existing records in Microsoft Dynamics 365 / CRM
As the creator of the Auto Number Manager tool in XrmToolBox, I get two questions more than any other questions: How can I number existing records?How can I add dynamic content to the numbers? To answer these questions once and for all, I will post my suggestions in two articles. I will step way outside my comfort zone of coding the solutions and give you strictly no-code… Continue Reading Jonas Rapp’s Article on their...
Bulk Data Updater for XrmToolBox – YouTube
Learn how to use the Bulk Data Updater tool for XrmToolBox to update values, trigger workflows and plugins, and even delete records in Microsoft Dynamics 365 / CRM. This tutorial demonstrates the basics of the tool, with live examples. XrmToolBox: Home · XrmToolBox XrmToolBox is a Windows application that connects to the Common Data Service for Apps (CDS). Dynamics 365 Customer Engagement (CE) applications, like Dynamics 365 for...
We created an XrmToolBox tool at Dynamics 365 Saturday Stockholm!
Last Saturday some 100+ experts, partners and user of Microsoft Dynamics 365 met up at the Microsoft offices in Stockholm, Sweden for a day packed with content at the Dynamics 365 Saturday event. I delivered two sessions at the event, and in one of them I took on a somewhat challenging session called Let’s build an XrmToolBox tool! I started with a few introductory slides, to set the stage,… Continue Reading Jonas...
Managed or Unmanaged solutions – a hot case still slightly open ⋆ The Dynamics 365 Trenches
The case is obviously not entirely closed. My recent article Case closed: Managed or Unmanaged solutions in Microsoft Dynamics 365 / CRM received a lot of attention, and sparked writers, podcasters, tweeters and commenters around the world to give feedback, yell at me, agree with me, or simply continue the discussion both publicly and privately. Readers of the “Case Closed” article… Continue Reading Jonas Rapp’s Article on...
Managed or Unmanaged solutions – a hot case still slightly open
The case is obviously not entirely closed. My recent article Case closed: Managed or Unmanaged solutions in Microsoft Dynamics 365 / CRM received a lot of attention, and sparked writers, podcasters, tweeters and commenters around the world to give feedback, yell at me, agree with me, or simply continue the discussion both publicly and privately. Readers of the “Case Closed” article last… Continue Reading Jonas...
Translating the Easy Way – YouTube
In this tutorial I will show you the benefits of using Easy Translator for XrmToolBox instead of translating youe Microsoft Dynamics 365 Customer Engagement or CDS environment using out of the box functionality. Home · XrmToolBox XrmToolBox is a Windows application that connects to the Common Data Service for Apps (CDS). Dynamics 365 Customer Engagement (CE) applications, like Dynamics 365 for Sales, Service or Talent also use the...
Case closed: Managed or Unmanaged solutions in Microsoft Dynamics 365 / CRM
If you have problems shifting gears in your car, you don’t call Volvo to say “Hey, I don’t like how this gear shifting thing works, so I’m just going to use reverse and drive backwards from now on.” What you probably do is call them to say “I’m having trouble shifting, you need to fix the problems or show me how to use it properly.“ Ever since Microsoft introduced the Solution platform...
Managed or Unmanaged solutions in Microsoft Dynamics 365
If you have problems shifting gears in your car, you don’t call Volvo to say “Hey, I don’t like how this gear shifting thing works, so I’m just going to use reverse and drive backwards from now on.”What you probably do is call them to say “I’m having trouble shifting, you need to fix the problems or show me how to use it properly.“ Ever since Microsoft introduced the… Continue Reading Jonas Rapp’s Article on their...
Portal Records Mover with Nick Doelman
MVP Nick Doelman shows us how to use the Portal Records Mover tool in XrmToolBox to copy Dynamics Portals configuration data from one Dynamics 365 CE organization to another. source
Telling VS to not use latest packages ⋆ The Dynamics 365 Trenches
When your C# projects are referencing NuGet packages, you are always encouraged to update to latest version.This can be annoying, when you really don’t want to. In the world of Microsoft Dynamics 365/CE/CRM, you may have to use SDK of previous major version (8.x), while Visual Studio still wants you to use the latest available packages (9.x). But there IS a way to tell Visual Studio to… Continue Reading Jonas Rapp’s...
A first look at FetchXML Builder for XrmToolBox
In this episode we will take a first look at FetchXML Builder for XrmToolBox. We will create basic queries, look at output options, and some of the setting. XrmToolBox: Home · XrmToolBox XrmToolBox is a Windows application that connects to the Common Data Service for Apps (CDS). Dynamics 365 Customer Engagement (CE) applications, like Dynamics 365 for Sales, Service or Talent also use the Common Data Service for Apps as their...
Introduction to XrmToolBox
In this episode I show how to set up XrmToolBox, how to install plugins, and have a look at some of the settings. XrmToolBox: Home · XrmToolBox XrmToolBox is a Windows application that connects to the Common Data Service for Apps (CDS). Dynamics 365 Customer Engagement (CE) applications, like Dynamics 365 for Sales, Service or Talent also use the Common Data Service for Apps as their foundational data service. Tweets by XrmToolBox Me...
FetchXML Builder and Friends at D365UG Virtual Summer Camp
On August 7-9, the first ever Virtual Summer Camp for the Dynamics 365 platform will take place. During this free event the D365UG offer some 30+ sessions with focus on Customer Service and Field/Project Service. I will be doing one of a few cross vertical sessions, where I discuss and demonstrate some useful XrmToolBox tools that help customizers, administrators and users with information… Continue Reading Jonas Rapp’s...
Relationship data analysis with XrmToolBox ⋆ The Dynamics 365 Trenches
Background Relationships in Microsoft Dynamics 365 Customer Engagement (CRM) and PowerApps Model Driven Apps can be decorated with a number of characteristics that define their behavior. These characteristics instruct the platform how to behave in regard to child data when different actions are taken on the parent record of the relationship. The configuration of relationships describe what… Continue Reading Jonas Rapp’s...
Use VSTS to publish XrmToolBox plugins ⋆ The Dynamics 365 Trenches
Recently a fellow D365 developer, Lars Müller, wrote an article on how to Build a versioned XrmToolBox plugin. I am taking this one step further, to show you how to create a complete CI/CD pipeline for your XrmToolBox tools. Of course, the primary reason for creating an automated pipeline for Continuous Integration / Continuous Deployment is to standardize versioning, naming, and any… Continue Reading Jonas Rapp’s...