Tip #1270: Table or view is not full-text indexed

Small green figurine of a toy t-rex

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 […]

Tip #1255: Say hello to PowerApps Component Framework

A disassembled electronic device parts on a table

At long last we have that abbreviation sorted out. CCF PCF or PowerApps control Component Framework a.k.a. Goodbye Web Resources is now available for public preview. It sounds grand and does hold the promise of changing the way we extend PowerApps, both model-driven and canvas. Read the announcement conveniently placed within the new PowerApps Component […]

Tip #1248: Stop using OrganizationProxy

"Do not block exit" sign on a mesh metal fence

One of the topics discussed during the MVP Summit 2019 was the brexit of SOAP API. I thought we dealt with it already but there is an additional small but important message: Stop using OrganizationProxy Matt “Platform Deity” Barbour Hold on, you may ask, didn’t you tell us that IOrganizationProxy is fine? Yes, it is, […]

Tip #1245: Tops and bottoms in April ’19 Release

Tops & Bottoms book cover by Janet Stevens

It’s great to see the team advising us in advance about the upcoming features in the April ’19 Release Notes. As with any forward document, it is a living and breathing beast. Some features are being postponed, some replaced, new stuff added. Some of the late-comers are new FetchXML operators. How often you wanted to […]

Tip #1236: Review RetrieveMultiple plugins before migrating to Unified Interface

Man looking into microscope

It’s not uncommon to register a plugin on RetrieveMultiple message and fiddle with the output, e.g. drop some values, add some calculations, etc. Chances are that you are changing the QueryExpression, and the plugin is working fine in the classic UI but you will have challenges migrating to Unified Interface. The reason is that in […]

Tip #1211: Mixing entities to build complex views

whisk on saucepan with organic eggs

The trick to get developers to get your job done for free is to challenge them. Which is exactly what Steve “Mr SMB” Mordue has done. Challenge I am trying to create a view of activities, that will show all activities performed by anyone on my team. I know I can create specific view that […]

Tip #1209: Embedding canvas apps in model-driven forms

Assorted wooden frames

For those of us who were continuosly torn between canvas apps (on yer device, pixel-perfect, task-oriented) and model-driven apps (a.k.a. good ol’ forms, views, you know, all that Dynamics 365/CRM stuff), the wait is finally over. Embedding canvas apps in model-driven forms is now available as Public preview. First, the official part. Makers can now extend […]

Tip #1198: Add email address to recipients in javascript

Six colorful mailboxes in a row

The advantage of having access to friendly brainpower is that the problems are getting resolved much quicker. The disadvantage is that it breeds inattentive coding. Daryl “Always Raising” LaBar almost threw in a towel but recovered and redeemed himself with the snippet how to add an arbitrary email address to the list of the email recipients […]

Tip #1179: Add a dash of dash to your autonumbering

Salt bae

&tl;dr Jonas “The Shuffler” Rapp reports: when modifying autonumbering for built-in entities like case, always include a dash in the pattern to stop Dynamics 365 from self-combusting. Long story One of the awesome users of the Auto Number Manager for XrmToolBox managed to break the system settings for Auto Numbers in Dynamics 365, so he […]