Dynamics 365 Update Currency Exchange Rates using Power Automate

Introduction:

In this blog, I am going to show you how to use Power Automate to update the currency rate in your Dynamics 365 CE instance. Power Automate allows you to create powerful workflows and connect to external systems. In the past, coding and development tasks were essential to the process of updating the currency rate in Dynamics CE. However, in this blog, we will walk you through the process of easily updating the currency rate without coding.

Learn more about our Microsoft Dynamics 365 services

Steps:

1. Navigate to your organizations, settings and then hit Business Management
2. Click New and add a new currency named Swedish Krona

3. The exchange rate for the SEK is 9.39
4. Go to the Customizations and Navigate to the Account
5. Add new Fields called Total Revenue, type Currency
6. Add the new field to the form as well as the total revenue base and exchange rate
7. Save and Purplish the changes

8. Navigate to https://make.powerapps.com
9. Choose your environment
10. Click on Solution
11. Click on Common Data Service Default Solution
12. Click New and select Flow
13. Name the Flow as Update Currency Exchange rate
14. Add Recurrence Action and set the interval to 1 and Frequency to Minute
15. Add another action, select Custom and then Select the Exchange Rates connector. To create the Exchange Rate connector go to URL for “Creating Custom Connector for Power Apps”
16. Type SEK “Swedish Krona” currency in the symbol field

17. Now if we execute the flow, we will get a JSON response. Hence, to update dynamics currency record, we would need to parse the JSON response
18. Add another action and Select Parse JSON

19. Select Body that was supplied by the Exchange Rate Connector
20. Click Generate from Sample
21. Type the Response you got from the API (Exchange Rate Connector)

{
  "rates": {
    "SEK": 9.3573926298
  },
"base": "USD",
          "date": "2019-12-27"
}

22. The platform will create the Schema as highlighted in yellow above
23. Add an action to define a variable and assign the value from the Exchange Rate to the variable

24. Add another Action and select the Common Data Service, Update a record

25. Type the Environment, Entity name and Record Identifier and Exchange Rate as shown in the image below

26. Save the flow and click on Flow Checker.
27. Before running the flow, let’s test the current exchange rate that was initially set to 9.39 as shown in step 2
28. Navigate to your organization and then Account, select an existing account and type values as highlighted. The exchange rate and total revenue base are read-only

29. Now Test the flow

30. As seen below the flow executed successfully

31. Now create a new account and let’s check the exchange rate, as seen from the image below the exchange rate is 9.35 instead of 9.39.

32. The flow will be automatically running every 1 minute to update the exchange rate that will be only an impact on the newly created records and not the existing records.

Conclusion:

Conclusively, the Power Automate platform takes automation business processes to the next level of efficiency. It has a user-friendly interface with simple steps to automate a task. This platform allows for regular updating of currency rates without the need for IT development.

If you have any questions or insights regarding this blog, feel free to leave a comment below.