Scheduling Workflows With Microsoft Flow

Cool stuff !!

That CRM Blog

I recently attended the MVP Summit in Redmond and one of the highlights was a ‘Developers vs Value-Adders’ cage match. Essentially, a business problem was presented and the two sides gave a solution using code and configuration respectively. The referee (me) judged the best response for each problem.

image

One problem that came up, courtesy of Jonas ‘The Friendly Developer’ Rapp was a classic bugbear in Dynamics 365: the issue of scheduling workflows.

image

If you are unfamiliar with the bulk delete job engine trick aka the ‘Wittemann Manoeuvre’, this was a workaround pioneered by MVP veteran Matt ‘Freakin’ Wittemann so many years ago. In short, you used the Bulk Delete scheduler to run a workflow.

So, given Matt came up with this trick about five years ago, is there another codeless way to achieve the same end with the new tools available to us? The answer is Flow.

Scheduling Workflows with…

View original post 619 more words

Call action with input & output parameters

Continue reading “Call action with input & output parameters”

Setting up a visual hierarchy on a custom entity

hier-main

Hierarchy visualisation can be configured in MSD 365, its pretty easy. Here are the steps for it. Continue reading “Setting up a visual hierarchy on a custom entity”

FetchXML Query with NOT-IN

Tips & Trics

If you want to get all available Resources of specific Resource Category that don’t have any booking for the particular period with FetchXML,  I tried NOT-IN clause and landed in following error,

Microsoft.Crm.CrmException: Unknown Condition Operator: not- in
at Microsoft.Crm.Platform.QuerySerializationUtil.ConditionOperatorFromString(String operatorText)

But OUTER join worked for the scenario and it gave the correct result. With small change it will give the result of get all Accounts who does not have Active Contacts or Opportunity does not have tasks in a specific time period.

Here is the code snippet for it

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true">
 <entity name="bookableresource">
 <attribute name="name" />
 <attribute name="bookableresourceid" />
 <order attribute="name" descending="false" />
 <filter type="and">
 <condition attribute="statecode" operator="eq" value="0" />
 </filter>
 <link-entity name="bookableresourcebooking" from="resource" to="bookableresourceid" link-type="outer" alias="bx">
 <filter type="and">
 <condition attribute="starttime" operator="on-or-after" value="2018-03-01" />
 <condition attribute="endtime" operator="on-or-before" value="2018-03-31" />
 </filter>
 </link-entity>
 <link-entity name="bookableresourcecategoryassn" from="resource" to="bookableresourceid" link-type="inner" alias="by">
 <filter type="and">
 <condition attribute="resourcecategory" operator="eq" uiname="Backhoe" uitype="bookableresourcecategory" value="{798E6C02-3BBE-E711-8123-E0071B686A81}" />
 </filter>
 </link-entity>
 </entity>
</fetch>

That’s it!

Thank You! 🙂

Web API and plural names

beware

JavaScript Plural name issue almost killed us, following post saved us. 🙂 …. CRM 2016 Web API and plural names … Thanks for the post nice post. I’m re-posting the article ..

The new Web API available for CRM 2016 is based on OData V4 protocol and the endpoint is /api/data/v8.0/

Continue reading “Web API and plural names”

{Quick Tip} Plugin registration tool stopped connecting to Dynamics 365

Saved my lot of time, Thanks Deepesh. Keep it up the good work… 🙂

MSDYNAMICSBLOG BY DEEPESH

In case you have been trying to get the Dynamics 365 SDK plugin registration tool to work for latest version of Dynamics 365 online and facing issues like this one:

· At making a connection stage the tool keeps on circling all the data centres and still does not connect and gives error such as Bad username or password

· Error during connection such as Bad request

· IF you pick specific data centre also, still get error while connecting.

Well, you need to download the latest plugin registration tool. Following simple steps help to download Dynamics 365 9.0 tools:

You can follow below steps with screens or for more details information look into Microsoft docs link

1. Open Power Shell from windows menu.

2. Navigate to folder location where tools will download.

clip_image002

3. Copy Paste following command in PowerShell command( referred from the Microsoft Link).

$sourceNugetExe = “https://dist.nuget.org/win-x86-commandline/latest/nuget.exe”

$targetNugetExe…

View original post 222 more words