Make HTTP Requests from CRM using Power-Automate

A few years ago, making an HTTP call from Dynamics CRM Services used to be very complex. The developers had to resort to C# Plugins or Workflows. In this blog, we will learn how we can consume an HTTP API by triggering an event from D365 CE (CRM) with the help of a Power-Automate (Flow). 

The requirement would be – Once a user creates a D365 Account providing values to Latitude and Longitude, a Power-Automate must make a GET request to the Bing Maps API and find the time zone based on the given account Coordinates.

STEPS

1. We create a new Power-Automate (Flow) that triggers on creation & update of account rows, provided the columns address1_latitude & address1_longitude are not empty. We also add a string variable called timezone_name.

2. Next, we add an HTTP action to make a GET request to the Bing Maps API. Here, the URI must be of the format:

You can create your own Bing Maps Dev Center key by signing into the Bings portal - https://www.bingmapsportal.com/. 

3. We parse the output of the above action into a JSON schema. The content would be (with the help of an expression) - @{body('HTTP_-_Get_Timezone')['resourceSets'][0]['resources'][0]}. The JSON schema is as follows:

4. Finally, we set the value of the timezone_name variable to genericName from the output of the Parse JSON output action. Save these changes in the Power-Automate.

UNIT-TESTING

• We create a new Account with feeding values to the Coordinates (Latitude and Longitude).

• We verify that our Power-Automate triggers and finds out the time-zone based on these coordinates as expected.

CONCLUSION

Hence, we were successful in getting an API response after making an HTTP GET request in our Power-Automate (Flow), which triggers an event in D365 CE (CRM). Likewise, we can make HTTP PUT, POST, PATCH and DELETE requests as well.

Stay tuned for upcoming blogs!