A use case I like with to use with Flow and Logic Apps is to create a workflow triggered by a Http Request that acts as an API endpoint. In a previous post I explained how to do it and how to configure Flow to the validate the Json payload. In that post the Json request was just a simple contact object with a few data fields that we inserted into Dynamics 365. Did know … [Read more...] about Flow – Http Request – Split On Collection
Flow to Email PDF from Dynamics 365 using the Word Online Connector
One of the never ending challenges of using Dynamics 365 was how to generate and email PDF's using data from Dynamics. While Word templates went some way towards solving the problem they have not been improved for a number of years. So generating PDF's usually requires third party tools. With the release of the new Word Online (Business) connector for Flow and Logic … [Read more...] about Flow to Email PDF from Dynamics 365 using the Word Online Connector
How to install the Data Gateway
I wrote a post a little while ago about how to use Flow to synch Dynamics 365 record changes to an on prem database using the Data Gateway. In this post I wanted to show how easy it is to install the Data Gateway. The data gateway acts a bridge between your on-premise data sources and your cloud services such as PowerBI, PowerApps, Flow and Logic Apps. You install … [Read more...] about How to install the Data Gateway
Logic Apps 429 Failure calling Dynamics 365
While doing some testing recently with Logic Apps I had some workflows fail with a status code of 429 when calling Dynamics 365 actions. A 429 status code indicates that the number of API calls to Dynamics 365 in one minute has been exceeded. This post explains how you can configure the concurrency setting of a Logic Apps workflow to avoid this problem. … [Read more...] about Logic Apps 429 Failure calling Dynamics 365
Flow to Synch Dynamics 365 with an On Premise Database
Up until recently synchronizing data in in the cloud with an on premise database was a major challenge which typically involved writing code. With the Digital Transformation revolution and the availability of a range of integration offerings in Azure this is no longer the case. Here is a sample Microsoft Flow which demonstrate how the creation of a contact record in Dynamics … [Read more...] about Flow to Synch Dynamics 365 with an On Premise Database
External Access to Dynamics 365 Using Azure AD
An option for providing users outside your organization with access to your instance to Dynamics 365 is to use Azure AD (Active Directory) . You add them as guest users in Azure AD, assign them a Dynamics licence and give them a security role in the instance of Dynamics they need to access to. It's as easy as that just follow the steps below. For this to work you need an … [Read more...] about External Access to Dynamics 365 Using Azure AD
Json Schema Validation in Logic Apps and Flow
You can create Logic Apps and Flow workflows that trigger on receipt of a Http request and optionally receive a Json payload. This technique can be used as an integration pattern in a B2B enviroment. You can design your Json scheme specifically for your partners so that is is easy to use and understand. This provides your integation partners with an API … [Read more...] about Json Schema Validation in Logic Apps and Flow
PowerApps and CDS 2.0 (Dynamics 365)
The Spring 2018 version of PowerApps saw the introduction of Dynamics 365 as the new CDS platform on which to build Model-Driven apps. As it is early days in the CDS journey the integration between PowerApps and CDS (aka Dynamics) may not be as smooth as you might hope. Here are a few observations that may be of interest in relation to PowerApps Environments and CDS solutions. … [Read more...] about PowerApps and CDS 2.0 (Dynamics 365)
Validate Web API calls using Custom Actions
I previously blogged here about how you can configure S2S, Server-to-Server, authentication to allow third party applications to query and update data in Dynamics 365 using the Web API. As the Dynamics 365 Web API is built on open http standards with libraries for a variety of languages the integration possibilities are endless. You can use Web API calls to integrate Dynamics … [Read more...] about Validate Web API calls using Custom Actions
Data Import Update
The out of the box data import In Dynamics 365 does not support updating records unless you do an export to Excel and and then re import it. This does not work where you are given a CSV file and need to use that to update records in Dynamics. Here is a quick NoCode way to do a data import and update records in Dynamics. What you need to do is to create an import entity … [Read more...] about Data Import Update
