Tip #1162: Microsoft Flow Functions Reference

If you are looking for an ultimate reference for the expressions that you can use in Microsoft Flow, it helps to remember that Flow is based on Azure Logic Apps. The functions reference is the same for both, and can be found here.

The original question was what functions are available in canvas PowerApps but not in Flow. While there seems to be no comparison guide, the PowerApps formula reference is available. Naturally, the list of functions in PowerApps is longer – in addition to “traditional” functions like Lower (toLower in Flow) it also deals with PowerApps-specific things like Named Operators, Signals, behavior fomulas, to name but a few.

(Facebook and Twitter cover photo by Jake Lorefice on Unsplash)

Tip #1161: Become real BAD this October

When we were planning Business Application Developer (BAD) Masterclass in Europe earlier this year, we didn’t expect the level of interest it would generate. London and Amsterdam classes were sold out, and the feedback was great.

Very much enjoyed. Two days full of knowledge, learning and excitement. Was a great experience to learn new things from such a great personalities. – Anagha

If you are a good Dynamics 365 / Power Platform developer or architect, then the BAD Masterclass is for you and it is coming to North America this October!

Follow the links, read the agenda and register for either wilderness of Colorado or trendiness of Toronto.

See you there!
David & George

Sponsored by our good integration friends at Kingswaysoft.

(Facebook and Twitter cover photo by Anthony Intraversato on Unsplash)

Tip #1160: Bring up client performance center

I’m known to be a bit verbose but at the same time I personally like the tips that are like nuggets – small, shiny, and mostly invisible.

This tip comes from Natraj “Always Debugging” Yegnaraman (and you can send your nugget to jar@crmtipoftheday.com too!).

Add perf=true URL param in UCI Unified Interface to display performance centre

That’s it, folks. Yes, we wrote about measuring your network and client (and in the process coining the word “insight” before it became all the vogue), we did talk about Dynamics 365/CRM monitoring and how not to turn it into a vanity exercise, and we did mention a cool shortcut to measure and troubleshoot form performance.

WAIT A MINUTE!

Pressing Alt-Shift-Q also summons the new performance centre in Unified Interface and old performance window in Classic UI. It works for the views and, unlike the old shortcut, does not close Chrome so that’s a bonus.

(Facebook and Twitter cover photo by Stefan Steinbauer on Unsplash)

Tip #1159: Run your script after business rules

Dynamics 365/CRM customizations inflicted by a customer are always fun. How can I tell their customizations apart? Easy, by the new_ prefix. Where things get really complicated if the customer later asks you to do something they are not sure how to.

Just recently I was asked to stop couple fields from being locked if the user has one of the preconfigured roles. The challenge was that those fields were locked as a result of elaborate concoction of business rules, the business rules cannot be selectively applied by role and there is no condition in the business rules that would allow role filtering. Sigh.

Option 1

Duplicate the form, scope the business rules to the original form only and grant form access only to the selected roles. It will kind of work but maintenance of multiple forms is no fun and I bet I would have been asked to automatically switch the forms.

Option 2

Rewrite rules as javascript. No, thanks, I choose life.

Option 3

Add straightforward script executing onLoad and onChange unlocking those fields for the selected roles. That sounds good. Sleeves rolled up, script written, wired in, and … no worky. Because, even though there is no definite documentation on the order of the execution, business rules tend to get in last, after all the custom event handlers have been accounted for.

The workaround is surprisingly simple. Javascript, as implemented by all browsers, is event-driven but single-threaded. That means if we create an event around our function, it will push the call into the queue behind all those pesky business rules scripts.

function doUnlockControls(fc) {
  fc.getControl("new_foo").setDisabled(false);
  fc.getControl("new_bar").setDisabled(false);
}

function unlockControls(fc) {
  if(userHasAnyRole(['Role 1', 'Role 2']) {
    setTimeout(doUnlockControls, 0, fc);
  }
}

function OnLoadAndOnChanged(execContext) {
  var formContext = execContext.getFormContext();
  unlockControls(formContext);
}

setTimeout function creates an event that gets pushed to the queue and executed after the business rules scripts, even with the timeout set to zero. So this workaround works if you have some code that you have to execute after the business rules. But, as with any unsupported workaround, use at your own risk, contains small parts, choking hazard, swim between the flags. Not tested on animals, children or CRM.

(Facebook and Twitter cover photo by Melanie Pongratz on Unsplash)

Tip #1158: Be very selective in the grid

As I was discussing the workaround for the N:N regression bug, I noticed that some of the users, especially those switching from classic UI, are somewhat confused how to disassociate the records in the Unified Interface.

The UI can be, indeed, a bit confusing, especially when the viewport is small and the subgrid switches to the card view. Many times I’ve seen users pressed Delete while they really meant Remove.

This is the context menu and this is exactly what you don’t want your users to do:

Delete Contact in N:N grid

Instead, use … > Select
Select N:N records

That will switch UI into select mode and, once one or more records are selected, the … will now contain the coveted Remove

Disassociate contact

The other good business practice in my books is to completely revoke Delete privilege on contact (and many other) records, and teach users to deactivate contacts instead. That preserves the integrity of the business data and enables a quick “recovery” process, if a mistake is made.

(Facebook and Twitter photo by Nathan Dumlao on Unsplash)

Tip #1157: Do not delete system components

When you provision a Dynamics 365 instance, it comes with a number of system views that may or may not apply to your scenarios. Take, for example, Contacts: No Campaign Activities in Last 3 Months. If you are not into marketing, why would you need one? As tempting as it could be to just go around and whack the system views you have no need for, DON’T.

If another solution, e.g. Dynamics 365 for Marketing, expects this view to be there, then the installation of that solution will fail.

Shan “Smoke ’em” McArthur, Principal PM at Microsoft, explains:

I do want to call out that I notice that many customers attempt to ‘clean up’ their CRM environment by deleting components they think they don’t need that are brought in via system solutions or ISV solutions.  We have a mechanism for them to hide forms and views and that is much more preferred to deleting the view as it is very difficult to bring back a deleted view to avoid future updates from the solution owners. It would be nice for customers to know that they can mark views and forms as inactive instead of deleting them – unless they are the owner of those forms and views.

Moral of the story: if you want to get rid of a system form or a view, deactivate them. Or consider building an model-driven app where you can select exactly which views and forms are available to the users.

If you did the unspeakable and deleted one or more system components, and there is no backup for you to restore, log a case with support who should be able straighten up your instance.

(Facebook and Twitter cover photo by Kyle Glenn on Unsplash)

Tip #1156: Locked fields out of the box

Long time ago Stefan Strube sent me this tip, I filed it away and forgot all about it (sorry, Stefan!). Until last week, that is, when I started new deployment and customer had specific need for couple rollups on account entity. Good news was that those rollups are out of the box: opendeals and openrevenue, so I dropped then on the form and left it be. Bad news was that the testers immediately complained that they can’t see these fields at all.

locked-fields

What the?

Tip from Stefan to the rescue! These rollup fields are Field Security enabled by default, therefore only the admins will see the calculated values but all other users will not.

To check what’s going on out of the box, create a new field security profile and, presto:

protected-fields

These are OOB fields that have field security enabled on them.

As per the original tip, if you want to make these fields available to (a group of) users, create a Field Security Profile for this and set Read privilege to Yes. Update and Create are not available simply because these fields are rollups. You probably noticed an interesting case of sharepointemailaddress field – Read privilege cannot be set at all. This is because the metadata flag CanBeSecuredForRead is false, meaning “You shall not deny user reading this field”. Oh, well, nobody knows what this is field is for, anyway. Wait a minute, turns out I do!

(Facebook and Twitter cover photo by Markus Spiske on Unsplash)

Tip #1155: The Clock is Ticking on Your Endpoint

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 deprecated and, if we are using it to access the Dynamics 365 organization web service, we need to update our code. The linked article says

The 2011 endpoint will be removed some time after the release of Dynamics 365 version 9

Given this is a little vague, Leon raised it at the CRMUG Summit EMEA in Dublin earlier this year. At that time it was confirmed by Microsoft that the 2011 endpoint will be around at least until the release of v10.

So when is v10 coming out? At the time we did not know. Now looks like we do! The October ’18 Release Notes are out. This means that, assuming Microsoft stick to their schedule, and assuming that October release will be, in fact, version 10, it will be out in October this year. What does this mean for your Dynamics implementation?

No one can express it better than Matt “Platform Deity” Barbour (this is somewhat abridged and modified version):

  1. The deprecation does not mean that the endpoint will be removed AT version 10. Microsoft has a lot of metrics for various things including the SOAP usage and continuously evaluates the consequences of removing something as fundamental as the endpoint.
  2. The Organization Service (the IOrganizationService Implementation), used in the CrmServiceClient and Plugin\Workflow system is NOT deprecated. For folks building plugins, using the IOrganizationService is the right way to go, and will remain so for the foreseeable future.
  3. With regards to the CrmServiceClient, nothing changed since the deprecation notice.

    We plan to provide updates to the Dynamics 365 SDK assemblies and tools over the next several minor releases, retargeting them to use the Web API instead of the 2011 endpoint.

  4. Which approach to use?
    • If you’re building plugins, build around IOrganizationService and other SDK assemblies.
    • If you’re building using the .NET framework, the CrmServiceClient is the way to go.
    • If you’re building on non-Microsoft platform or .NET Core\Standard [at the moment], the Web API is the way to go.

Note that Web API is not explicitly mentioned in #2. For new developments you may want to consider Web API as well but do not expect the same level of support as exists for .NET, e.g. strong type support, authentication wrappers, diagnostics and such.

Why? Because OData, as an industry standard, has many different ways and methods folks can adopt to do this. Each offering their own flavor of features and capabilities to support the needs to the technology that is implementing it.

I’m sure that with time we will see 3rd party Web API wrappers emerging (and they do already exists) that will make development easier, and purists and minimalists happier. 

Call for action

Check the code that is talking to the Dynamics 365. Ensure that the code is using either Web API or SDK assemblies. This does not mean just plugins but anything integrating to Dynamics. It may be integration to another system or a custom web form application. All interactions need to be checked and if they are explicitly replying on the 2011 endpoint, bring them up to standard. The clock is ticking.

(And as painful as it is for me and many others, we’d have to admit that George was rightalmost two years ago.)

Tip #1154: When Unified Interface misbehaves

We know that Unified Interface is not yet on par with the classic UI. Some things are not yet there, some things will never be there because there are better ways to achieve the same results.

Since Dynamics 365 is a continuously updated beast, sometimes bugs and inconsistencies make their way into a working feature. The other day I was asked by Brent “I am a little afraid of what’s to come” Howard why, after the latest update for the Unified Interface (1.3.230-180801-000211) has removed the ability for users to Associate records in a N:N relationship. (To qualify: not just any relationships but the ones that involve contacts – t.j.). The workaround is for the user to switch out of the Unified Interface and use the classic UI however most of their work force are using the mobile interface and are only very basic PC users.

Walkthrough

When you add N:N relationship between an account and a custom entity, say, foo, and then add a subgrid to the account form, the menu looks like this:

N:N grid with Add Existing

That allows to associate an existing Foo record and create a new one if needed (association side panel has a +New button).

If you add a new N:N relationship between account and contact entity then subgrid menu will look like this:

N:N grid without Add Existing

Note that Add Existing is just not there.

Workaround

Kudos to Brett for finding the workaround that involves, you guessed it, poking around with the Ribbon Workbench.

  1. Create a small solution that includes contact entity and application ribbons.
  2. Open either standalone Ribbon Workbench or as part of the XrmToolBox and load that solution
  3. On the SubGrid ribbon you’ll find two Add Existing {0} buttons, select one with the Id of Mscrm.SubGrid.contact.AddExistingAssoc
  4. It’s a system button so nothing will show up until you right mouse click and select Customise Command (note that Scott is from UK and sneaked in correct spelling of the word Customise)
    Customise command for system button
  5. That will light up Solution Elements panel where you’ll find Mscrm.NotUci enable rule. The rule looks like this
    The rule that removes the Add Existing button
  6. Right click > Delete (you do have a backup, don’t you?)
    Delete the enable rule
  7. Publish the solution, then reload the form and here we go:
    N:N contact grid with Add Existing command

If I have to guess, the regression bug is in Xrm.Internal.isUci function from the Marketing/ClientCommon/Marketing_ClientCommon.js web resource but let’s wait and see how it’s going to be fixed.

(Facebook and Twitter cover photo by Tomas Sobek on Unsplash)

BAD Masterclass

BAD Masterclass 202? Promotion

Tip of the Day and 365.Training present Business Application Developer (BAD) Masterclass

int year = 2019++;

// 2020-21 patch
year = covid(year);

string what;
if(whoAmI == "developer") {
  what = donthavetime ? 
         "BAD Ramp-up" : 
         "BAD Masterclass";
}
else if(whoAmI == "administrator") {
    what = "SAD Workshop";
}
else {
    what = "MAD Workshop";
}

Console.WriteLine($"Attend {what} in {year}!");

What is it

The Power Platform has a rapid release cadence and with that come the new features, new developments, and new challenges. In case you were not paying attention, the waves are coming every 6 months. This is your chance to get your hands on the new technologies and learn the new stuff before anyone else. Hear the news from the latest conferences and what does it mean for Business Application Developers.

Y’all busy people so in 2020 2021 💉💉 2022 we’re hoping to be back!

Who’s behind it

BAD Masterclass is a brainchild of yours truly, George Doubinski, co-founder of CRM Tip of the Day and CRM.Audio and David Yack, developer and trainer extraordinaire, and author of https://xrm.tools.

SAD Workshop is the creation of Joel Lindstrom, co-founder of CRM Tip of the Day and CRM.Audio

MAD Workshop was co-created with Julie Yack (yes, that  Julie Yack – trainer, author, mentor, learner, problem-solver and globetrotter).

What’s in it for me

Are you BAD?

Unlike any of the courses and trainings you find, it’s not about what you can do in Power Platform / Dynamics 365 world today, it’s about what will you use tomorrow. Aimed at proficient developers at the level 300-400, it covers new and upcoming technologies, trends, and best practices you need to create Business Applications for the future. It is delivered as a mix of presentations, talks, discussions, hands-on exercises, and developer challenges, all packed within 1 or 2 days of in-class learning.

This class is for all you experienced Power Platform/Dynamics 365/CRM developers who want to take your skills to the next level.

Are you SAD?

Are you a system administrator, whether by choice or by accident, and not sure how to deal with bazillions of options now available? Have to navigate between admin portals, monitor everything under the sun, and curb enthusiasm of citizen developers at the same time?

Just in one day you’ll learn how to keep all your Power Platform/Dynamics 365/CRM environments, developers, and users under control. No more sad administrators!

Are you MAD?

We’ve been repeatedly asked not to let developers have all the fun. We listened. Introducing Managing Application Developers (MAD) Workshop.

Managing your business application developer team doesn’t have to be difficult. In this half-day workshop we’ll discuss communication strategy, common misunderstandings between business and technical teams and learn about leading your team with a good application lifecycle plan.

Some of the planned discussion topics:

  • Can you fire all developers now?
  • What are your developers not telling you?
  • Make peace between developers and citizens

MAD Workshop runs in parallel with BAD Masterclass and is designed for team leaders, project managers, CTOs, CEOs, and all other people who are actually responsible for the teams, technology, and, ultimately, projects success.

While your developers are learning BAD, discover how to make the full use of that knowledge.

Where

  • 6 – 7 July 2020 Auckland & Wellington – BAD, SAD, MAD (Registration coming up) 😭
  • 13 – 17 July 2020 Sydney & Melbourne – BAD, SAD, MAD (Registration coming up) 😭
  • 23 March 2020 Vancouver – BAD Ramp-up ❌😡
  • 26 February 2020 London – BAD Ramp-up
  • 27 February 2020 Glasgow – BAD Ramp-up
  • 21 – 22 October 2019 Toronto (sold out)
  • 13-14 June 2019 Hawaii
  • 10-11 October 2018 Colorado
  • 4-5 October 2018 Toronto (sold out)
  • 31 May-1 June 2018 London (sold out)
  • 28-29 May 2018 Amsterdam (sold out)
  • 24-25 May 2018 Milan

BAD Agenda 1 Day

{
  breath(in);
  
  var agenda =
    "Solutions/ALM/TypeScript/.NET Core/Azure/"
  + "Canvas/PCF/Power Automate/Custom Connectors/"
  + "Security/"
  + "Hands on exercises";

  breath(out);
}

SAD Agenda 1 Day

  • Environment Management
  • Power Platform Security
  • User and Permissions
  • Document Management
  • Email Management
  • Data Management

BAD Agenda 2 Days

Day 1

  • Introductions and BAD Challenges
  • What’s new and what’s old for the Developer
  • Solution framework – do it right
    • Work time – Solution challenge
  • Advanced Data Modeling
  • PowerApps Portals
  • Canvas for developers
    • Work time – Canvas for developer
  • PCF
    • Work time – PCF

Day 2

  • Authentication done right
    • Work time – Authentication
  • Azure Survival Kit for Power Platform developer
    • Work Time – Azure
  • Flow for developers
    • Work time – Flow for developers
  • Custom Connectors
    • Work time – Custom connector
  • Survive and prosper in locode/nocode world

Note: Agenda is subject to change