• Eventbrite to CDS Integration - Part 6 (Testing)

    In the final post, we will quickly view the results of this entire process. We will create an Event in Eventbrite, and add an attendee to this event, and then verify that the Event has been created in CDS as well as Attendee added to the Contacts entity and linked to that Event.

    Continue reading...

  • Format Text by using PCF Control and Regular Expressions

    On one of our recent projects, we had a requirement to only allow valid Tax Id Numbers on that field. There are various ways of implementing this, but as the direction seems to be to shift the development of these kind of features to custom controls, we decided to implement it as a PCF custom control.

    Continue reading...

  • Using Flow to get the country of a website visitor

    There are many tools for tracking visitors and page views to web sites, but in certain circumstances this might be something that you would want to implement on your own. It is simple enough to get the IP address of the visitor of the web site, but usually in order to get the country we need to call some sort of API. There are various API provides that can give you this information, and in the case of this blog post, I selected a provide called ipgeolocation (ipgeolocation.io).

    Continue reading...

  • Embed a simple Power Virtual Agent in Power Apps Portal

    A little late in the game as Power Virtual Agent is already in Public Preview and trials are available, but I wanted to demonstrate how easy it is to create a bot, publish it and add it to your Power Apps Portal page.

    Power Virtual Agents allows user to quickly and easily create powerful bots using a graphical no-code graphical experience. To start creating our first bot, we navigate to powerva.microsoft.com or aka.ms/TryPVA which will redirect to powervirtualagents.microsoft.com.

    Continue reading...

  • Configuring oAuth authentication for CDS

    It has been quite some time since Microsoft announced the use of oAuth to connect between Server environments, but many organizations are still using username and password to connect to Dynamics 365 or the Command Data Service (CDS).

    I recently had to work on a migration project, and while this customer was using legacy credentials to authenticate, they had no problems doing so with all of their environments. After they provisioned a new environment, suddenly they started receiving authentication exceptions from their data migration tool (using Kingswaysoft and SSIS).

    Continue reading...

  • Generate Document Templates in CDS using Flow

    One of the features in Microsoft Dynamics 365 (and some of the previous versions has been document templates). I wanted to validate some of the logic, if we can automate the creation of a document and sending it as an email using Microsoft Flow, and of course Flow did not fail to perform.

    In order to implement this logic, the first thing was to create the actual document in Microsoft Word. This document will be the template that we create, and will convert it to an Adobe PDF and finally Send it in an email message using Office 365. This process is based on a requirement to generate a license and send it as an email to the user when a new license is generated (or updated).

    Continue reading...

  • What new in the Common Data Service Connector?

    With the Power Platform Wave 2 release, we started noticing some progressive changes to the Common Data Service connector. When you do a search for “Common Data Service” in the connector search box, you will see two separate connectors. The first connector which we are used to is still called the Common Data Service connector, but you will notice that there is an additional connector called Common Data Service (current environment) connector.

    Continue reading...

  • Creating a NAICS Code PCF Control using WebApi

    In many of the projects that I have worked over the past years, either government of private sector, while working with other businesses it has become a common practice to request that Industry information from the companies that you work with, and furthermore the NAICS code. While not every company knows their NAICS code, drilling down to get it using the Industry (2-digit code), Subsector (4-digit code) and NAICS title (6-digit code) might be the way to go, sometimes you might want to bypass this complex search if you know ahead of time your business’ NAICS code and have it auto populated for you.

    Continue reading...

  • Creating a simple canvas app component

    As part of the 2019 October Release (Wave 2), Microsoft is introducing PowerApps Canvas App Components. Canvas App Components are reusable components that can be shared across multiple screens of your app, without the need to create or copy the component across the multiple screens. Create once, and use multiple times. Canvas App components can also be imported and exported, so that they can be used across multiple applications. This post will demonstrate how to create a simple component, add custom properties and use it from within your Canvas application

    Continue reading...

  • Error Notification UCI Enhancements in October Release

    As part of the October 2019 release (Wave 2), the Unified Interface will receive a few usability enhancements that will address some of the issues that were reported by the community. These enhancements include: Anchoring error notifications, Viewing inline images for emails that are read-only, Improved usability/density and filtering in views and form header usability enhancements.

    Continue reading...