Power Platform & Dynamics Blog by Gustaf

Mostly technical stuff I have run into and want to share

API per user limits – The good, the bad and the ugly

Microsoft recently release some throttling that have been causing some stir in the community, especially since the latest throttle, the concurrency throttling, was not very openly announced, some partners and customers were hit rather hard by it as it affected their abilities to manage large dataloads in the system.

Now Microsoft have announce another API based limitation which is based on the users and the type of licenses the have. You can read some about it here if you like. This article will discuss what this means and my personal view of the good, the bad and the ugly of it.

Fast data management in a limited CDS world

In May 2019 Dynamics 365 CE/CDS enacted some new throttling mechanisms that have caused some headaches for anyone wanting to manage a lot of data in CDS (I will refer to Dynamics 365/CDS as just CDS below). There are several different throttles but the one that has cause me most trouble is the concurrency throttle. Kingswaysoft will release support for handling this in the next release and you can also request a special version from them if you ask nicely. In the meanwhile this post can give you some help on how to work as fast as possible using application user mulitplexing and a loop with a 5 min wait to make sure that the throttles are reset.

How to reduce SubscriptionTrackingDeletedObject table in CDS/Dynamics 365 – Updated!

SubscriptionTrackingDeletedObject is a mysterious table that can grow to a large size in CDS/Dynamics 365 CE instances where a lot of deletion is done. This article will tell you how to change install a tool that allows you to change the retention period of the logs in this table to reduce its size. – UPDATED! Based on some new information I have now updated this article!

Forms Pro Flow activity set regarding

Using Flow to send a Survey in Forms Pro uses a different syntax than the CDS connector for setting the regarding fields to CDS related data. This is how.

TCP Chimney

Today I was working with a customer and we have had some weird SSIS intermittent errors where the Native OLE DB / SQL Client was giving me some trouble with really weird errors. Errors like these: CRM service call returned an error: CRM service call returned an error: The request channel timed out...

Azure guest accounts in CDS/Dyn365

Azure Active Directory (AAD) has a feature where it allows users of foreign tennants to be granted access to the current tennant. In other word, if you are running contoso.com and a user of northwind.com would like to have access, you can add this user as a guest account in Azure. However, I have found that giving this user access to Dynamics is not fully straight forward, although, it is far from rocket science. In this article I will show how this is done.

Uninstalling Employee Self Service Portal – step by step

A customer of involontarily gotten a Dynamics 365 Employee portal installed. I had to remove it. It has 21 (!?) solutions which are interdependent. This is how I fixed it.

Server Side Sync with Forward mailbox and SMTP

Most often when setting up server side sync, especially in Online environments, Dynamics 365 CE/CDS is connected to Exchange Online. This is rather straight forward. Even in less straight forward cases like On-prem to On-prem or the so called hybrid cases of on-line to on-prem where the involved...

New times, new blog – less nagging!

Time for a new blog engine, time for a new blog title and time for my own domain to blog from and above all, time for Jonas Rapp to stop nagging about me blogging on blogspot. Old blog is still up and running and I will keep it there for some time as long as people find interesting stuff there. As...

Formating Web API query for getting VoC Survey questions

Working with a Flow to do some text analysis and sentiment analysis on Voice of the customer responses. The trick, as the payment model is per run, is to trigger it per Survey Response, and not Question Response. Hence the logic has to loop through all the question responses. The way you create a...
Gustaf Westerlund

Gustaf Westerlund

8xMVP

Working as consultant since version 1.2. Involved in between 150-200 projects. Founder and Principal Consultant at CRM-Konsulterna.