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

Get Record CDS action missing attributes in Government Cloud

by Levin, Aric

Azure  Common Data Service  Flow  Government Cloud 


Posted on 1/18/2020 10:57:00 PM


While most of you might not be experiencing this issue, it is still a good workaround for a situation that you might have. Recently we had a situation that when we tried to retrieve the account record using the Get record action in our Government Cloud instance, but the results did not retrieve all the attributes. The attribute that we were really having an issue with was the address1_name.

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

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

Using Flow to get the country of a website visitor

by Levin, Aric

Common Data Service  Flow 


Posted on 12/20/2019 2:51:00 AM


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).

Read More

Generate Document Templates in CDS using Flow

by Levin, Aric

Common Data Service  Dynamics 365  Flow  Messaging  Office 365  SharePoint 


Posted on 11/3/2019 1:50:00 AM


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).

Read More