How to find parent record with at least one child record or with no child records from Advanced Find

Now it is very easy to get the parent records with at least one child record or with no child records from Advance Find like below

Before this feature got introduced, it was not possible to query the records from Advanced Find, you have to download the fetchxml and modify the filter type to “outer” and create a view or report with the modified fetchxml.

Hope it makes easier everyone’s life……

Microsoft Dynamics 365 for Outlook is unable to render entity views (web pages)

After installing the August 2018 Office update, we are struggling with the error message “Waiting for a page to be retrieved from a Microsoft Dynamics 365 server…” when using Microsoft Dynamics 365 for outlook app.

Solution

As a workaround while this issue is under investigation, navigate to the following location within Outlook:

File -> Options -> General -> User Interface Options -> When using multiple displays

Change the value of this setting to “Optimize for compatibility” (it will also notify you an application restart is required).

Outlook Multi-monitor optimization

Once Outlook is restarted, the webpages within the Microsoft Dynamics 365 for Outlook will be able to render webpages again. 

This can also be enforced through GPO via the following registry location (ensure to restart Outlook if running while this is set):

[HKEY_CURRENT_USER\SOFTWARE\Policies\Microsoft\Office\16.0\Outlook] “ForceLegacyDpiAwarenessMode”=dword:00000001 

CRUD Operations with javascript from V9.0

Microsoft introduced an awesome feature for developers with V9.0 called Xrm.WebApi. With this feature it is very easy to perform CRUD operations using javascript code. Earlier to v9.0, to perform CRUD operation in Dynamics CRM we need to create our own library or used other third party libraries or used XmlHttpRequest and ajax request. Example code to perform CRUD operations using Xrm.WebApi feature

  1. Create
This image has an empty alt attribute; its file name is image.png

2. Update

3. Delete

4. Retrieve

Export SSRS report to server folder as a PDF

Today we got a requirement to export the SSRS report to server daily in the morning with out asking any prompt. Initially I thought of writing a console app to export the SSRS as PDF and schedule that console app. But after some research I found a concept called “Subscriptions for native mode report server”, with this feature you can deliver the report through e-mail or to a shared folder as per the schedule defined. Refer this link for complete details like Create, Modify and Delete Subscription. Below is the screenshot of subscription that I created for my report.

Subscription details

Schedule details

How to use special date operators (last-month for ex) in OData and MS Flow

Today we got a requirement to fetch all the records that are created in the last month by using MS Flow. We can do this by using “Dynamics 365 List records” action and we have to provide OData filter query for this action. I tried to use the same “last-month” operator that we use in the fetch xml. But this will not work for OData query. We need to use “LastMonth” function for this as defined in this link. The below are the examples to use these date functions.

In OData Query

?$filter=Microsoft.Dynamics.CRM.LastMonth(PropertyName=@p1)&@p1=’createdon’

In MS Flow

Hope it is useful….