When you need to insert, update, or delete a large number of records in Dataverse, synchronous plug-ins can get in the way. Asynchronous plug-ins and Power Automate flows are triggered independently (out of process) but can be overwhelming for the system and can be throttled down. Did you know you can bypass either? Did you […]
I need to perform some data… uhm… “augmentation”. Easy as using Power Automate – get all the records, loop through, fudge I mean augment the data. Right? Except there could be more than 100,000 records. Why 100K? That’s the maximum you can get with the List Records action. (Wanted to insert a reference here but […]
Today’s tip is from Marius Agur Hagelund “Viking” Lind (actually, I’m confused, perhaps it’s Marius “Viking” Agur Hagelund Lind?). Got a tip of your own? Send it to jar@crmtipoftheday.com. Cannot use CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed Mean SQL Server If you’ve ever got this error […]
This is very much a collaborative post. Leon had a first go at it, George threatened to rip it all apart if posted because of the tiny technical inconsistencies. The verbal abuse discussion ensued, links were cross-checked, and now we have this. We have known for a while that the Dynamics CRM 2011 endpoint is […]
When you use Microsoft Flow to create a Dynamics 365 activity record, e.g. task, it’s a good practice to relate the activity to another record by setting up Regarding field. Use dynamic values and drop the related record into the Regarding box, right? If you do just that, your flow may fail with the following […]
The week of “just read your mailbox and publish what other smart people found”, continues. Derek Finlinson has the microphone: Ran into an interesting issue with the Web API and expanding navigation properties today that I thought I would pass along. I needed to retrieve an attribute from a lookup value related to an entity […]
Shiny Dynamics CRM Web API has a number of useful functions that you can call using simple GET. Like ubiquitous WhoAmI: https://notarealorg.api.crm.dynamics.com/api/data/v8.1/WhoAmI, nifty RetrieveOrganizationResources: https://stillnotarealorg.api.crm.dynamics.com /api/data/v8.1/RetrieveOrganizationResources, or canny RetrieveDataEncryptionKey: https://yesthisisarealorg.api.crm.dynamics.com/api/data/v8.1/RetrieveDataEncryptionKey. Some of these functions require parameters and documentation how to pass parameters is available. Except that the documentation does not explain how to deal with […]
Turbocharge your PowerBI Connectivity to CRM – Amaze your friends and strangers! Working in a hardened bunker deep on the mysterious island of “Advanta”, the Microsoft CRM team’s top scientists have unleashed a powerful new API for connecting to CRM. It’s known only by the secret codename “Instance Web API” and today your semi-humble tipster […]
Even the best of us are still finding their footing with new shiny CRM Web API. Tipsters to the rescue in another mini truck stop. Andrii “Granny’s Moonshine” Butenko was wondering what is the best way to fetch Global OptionSets using Web API (from now on apiendpoint == https://orgname.crm.dynamics.com/api/data/v8.0): I can get all global optionsets […]
As of CRM Online version 7.1 there is another new tab on the Systems Setting configuration window. The new previews tab is where the CRM Admin will enable access for their organization to some really cool new features – IFRAME in tablets, the Web API Developer Preview and my personal new favorite the CRM App […]
of the