Copying content from a Word document or from a website into the clipboard, also copies the information of how this content is formatted (font, color, etc.) into the clipboard. When you paste it into a Rich-Text-Editor (WYSIWYG-Editor), most of the editors try to merge it … somehow … and the result looks like an accident.
To paste without formatting, you can use simple shortcuts.
Posted in ClickDimensions, Dynamics 365, and Power Platform
If you’ve ever wonder why the count of your marketing lists members differs from the email statistic that ClickDimensions has sent, then the following list will help you to understand how ClickDimensions calculates the email delivery.
This list contains the OData 4.0 queries to collect all the data for email delivery and interactions for reporting purposes.
GET [Organization URI]/api/data/v9.1/An inferred open is counted when a recipient clicks a link in an email or unsubscribes, but does not download the images (and also the tracking pixel) in the email.
The unique opens in the email statistics in Dynamics 365 CE do not include inferred opens.
The ClickDimensions email report includes the inferred opens in its unique opens count.
Basics for marketeers but maybe not for Dynamics 365 folks and of course it is also handy to have all in one place.
Posted in Dynamics 365, ClickDimensions, and Power Platform
ClickDimensions has a monthly release cycle with a yearly major release. Surely you can imagine that most of the customers don’t prefer the automatic update and of course nobody makes manually updates on a regular basis.
The result of this combination is that I get often the question from customers: “What has changed since our last update?”.
The release notes of ClickDimensions are public available as single articles, starting from Feb 2018 – v9. These article contain the changes for each single version.
Therefore, I started my own document that combines these releases notes articles, and I want to share it with you.
Or in other words: “Benefits of bringing them in all together in an Excel file.”
Posted in Dynamics 365, and Power Platform
Counting records in CRM can be tricky and time consumption when there are more than 5.000 records in the table. There are several ways and tools to do this that are already well described in the community.
When you are fine with the fact that the numbers you receive are static from a count last night, you can use the RetrieveTotalRecordCount function.
There are descriptions in the community on how to use it, too:
I combined both and created a bookmarklet, so that you don’t need to to memorize the url path or modify a bookmark everytime when you are in a different system or need another table (entity).
Create a normal bookmark in you browser and replace its url with the following code:
javascript:function proc(){var r = JSON.parse(this.responseText).EntityRecordCountCollection,t = [];for (let i = 0; i < r.Keys.length; i++) {t.push(r.Keys[i]+"="+r.Values[i])}prompt("Result", t.join(","))} etn = prompt("EntitySchemaName as CSV?", "account,contact").split(",").map((str) => str.replace(/\s/g,''));var oReq = new XMLHttpRequest();oReq.addEventListener("load", proc);oReq.open("GET","api/data/v9.1/RetrieveTotalRecordCount(EntityNames=['"+etn.join("', '")+"'])");oReq.send();You can use it at any place inside of D365 CE. You only need to write in a SchemaName of an entity (table) or several, comma separated SchemaNames and it answers you with the EntitySetName and the number of records in it (counted last night).
Posted in Dynamics 365, Power Automation, and Power Platform
Almost six years after my last post about bookmarklets, I’m proud to present you a new bookmarklet for Dynamics 365 CE.
It can be used to retrieve the EntitySetName for for an entity (table).
In case you don’t know what the EntitySetName, here is what Microsoft writes about it.
This value is used in the resource path for this entity in the Web API. For custom entities, you can change the name of the entity set used. By default it is the same as the LogicalCollectionName.
Source: Microsoft Docs
In other words, you need when you use the WebApi or the Common Data Service (current environment) connector in PowerAutomate.
Create a normal bookmark in you browser and replace its url with the following code:
javascript: etn=prompt("SchemaName?","account");var xhr=new XMLHttpRequest;xhr.open("GET","/api/data/v9.0/EntityDefinitions(LogicalName='"+etn+"')?$select=EntitySetName",!0),xhr.onload=function(t){4===xhr.readyState&&200===xhr.status&&prompt("EntitySetName:",JSON.parse(xhr.responseText).EntitySetName)},xhr.send();You can use it at any place inside of D365 CE. You only need to write in the SchemaName of an entity (table) and it answers you with the EntitySetName from the EntityDefinitions.