Connecting to MS Power Automate Flow from a Web Application

by Levin, Aric

Dynamics 365  Flow  Web 


Posted on 2/11/2020 9:21:00 PM


It is a very trivial scenario that we would want to create a Common Data Service entity record from a web page. An example can be a contact us page or request for help that would create a lead or a case in Microsoft Dynamics backend. Although Dynamics Portals (and now Power Apps Portals) are available for this kind of integration, many organizations still use other types of web applications and they need to integrate with the Common Data Service, such as various web to lead products.

Read More

UCI Grid Filtering and Search improvements

by Levin, Aric

Common Data Service  Dynamics 365  Power Platform  PowerApps  Unified Interface (UCI) 


Posted on 2/2/2020 1:30:00 AM


Over the past couple of years, since the release of Unified interface, one of the biggest pain points for most customer was that features that are available in the web client are not available in the new Unified Interface. There were a lot of improvements in the Unified Interface with the responsive client, custom controls and more, but when you are used to working in a certain way, taking away features is sometimes hard to get used to.

Read More

Integrate CDS and SQL Server with Power Automate and On-Premise Data Gateway

by Levin, Aric

Azure  Common Data Service  Dynamics 365  Flow 


Posted on 1/8/2020 11:28:00 PM


In a recent blog I posted a few days ago, I posted how to use Azure Service Bus and a Listener application to integrate between the Common Data Service (Dynamics 365 or Power Apps Model Driven Application) and an On Premise SQL Service database. As mentioned that there are a few easier ways to implement this, I wanted to demonstrate how easy it would be to perform similar functionality using a Microsoft Power Automate Flow that connects to the On-Premise Data Gateway

Read More

Configure Azure Service Bus to integrate between CDS and On-Premise SQL database

by Levin, Aric

Azure  Common Data Service  Development  Dynamics 365  PowerApps  SQL 


Posted on 1/6/2020 2:17:00 AM


In this blog post I will demonstrate how to use Azure Service Bus and a Listener application to integrate between the Common Data Service (Dynamics 365 or Power Apps Model Driven Application) and an On Premise SQL Service database.

Read More

Eventbrite to CDS Integration - Part 1

by Levin, Aric

Common Data Service  Custom Connectors  Dynamics 365  Flow  Power Platform 


Posted on 12/29/2019 6:30:00 PM


In this series of posts, I will demonstrate how to integrate between Eventbrite and the Power Platform by creating a Model Driven App to store event information, Creation of Microsoft Flow to execute when a new event is created or a new order is added to an event in Eventbrite, and the creation of a Custom Connector to retrieve the event details from Eventbrite.

Read More

Eventbrite to CDS Integration - Part 2 (Eventbrite Settings)

by Levin, Aric

Common Data Service  Custom Connectors  Dynamics 365  Flow  Power Platform 


Posted on 12/29/2019 6:30:00 PM


In the second post will concentrate on the configuration of Eventbrite. We assume that you have already an Eventbrite account and you can create your own events. If you don’t have an Eventbrite account yet, this is the time to create one. You only need an email address and to set a password in order to create an Eventbrite account. Eventbrite is available as a free or paid service. Everything in this series of posts was done using the free Eventbrite account.

Read More

Eventbrite to CDS Integration - Part 3 (Custom Connector)

by Levin, Aric

Common Data Service  Custom Connectors  Dynamics 365  Flow  Power Platform 


Posted on 12/29/2019 6:30:00 PM


In the third post will create our custom connector in order to connect with Eventbrite. The custom connector will allow us to call the Eventbrite api to retrieve the required information about the Events and the Attendees that have not been provided by the Webhook.

Read More

Eventbrite to CDS Integration - Part 4 (Event Flow)

by Levin, Aric

Common Data Service  Custom Connectors  Dynamics 365  Flow  Power Platform 


Posted on 12/29/2019 6:30:00 PM


In this fourth post we will update the original flow that we created for when a new event is created in Eventbrite. The flow should have a couple of steps as the baseline. The steps include When a HTTP request is received, and the Initialize Variable action.

Read More

Eventbrite to CDS Integration - Part 5 (Attendee Flow)

by Levin, Aric

Common Data Service  Custom Connectors  Dynamics 365  Flow  Power Platform 


Posted on 12/29/2019 6:30:00 PM


In this fifth post we will update the original flow that we created for when a new attendee is registered in Eventbrite. Your flow should have a couple of steps as the baseline. The steps include When a HTTP request is received, and the Initialize Variable action.

Read More

Format Text by using PCF Control and Regular Expressions

by Levin, Aric

Common Data Service  Dynamics 365  Dynamics CRM  Power Platform  PowerApps  PowerApps Component Framework (PCF)  Unified Interface 


Posted on 12/25/2019 4:34:00 PM


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.

Read More