Dynamics 365 Update Currency Exchange Rates using Power Automate

Introduction

In this blog, I will show you how to use Power Automate to update the currency exchange 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 updating the currency rate in Dynamics CE. However, this blog will walk you through how to update the Currency Exchange Rates without coding easily.

Learn more about our Dynamics 365 Services

How to Update Currency Exchnage Rate: Step-by-Step Guide

  1. Navigate to your organization’s settings and then hit Business Management
  2. Click New and add a new currency named Swedish Krona
this image shows Business Management new currency
  1. The exchange rate for the SEK is 9.39
  2. Go to the Customizations and Navigate to the Account
  3. Add new Fields called Total Revenue, type Currency
  4. Add the new field to the form as well as the total revenue base and exchange rate
  5. Save and Purplish the changes

Read more: Microsoft Power Automate: A Low-Code Solution for Automating Your Processes

this image shows revenue base and exchange rate
  1. Navigate to https://make.powerapps.com
  2. Choose your environment
  3. Click on Solution
  4. Click on Common Data Service Default Solution
  5. Click New and select Flow
  6. Name the Flow as Update Currency Exchange rate
  7. Add Recurrence Action and set the interval to 1 and Frequency to Minute
this image shows Recurrence Action
  1. Add another action, select Custom, and then Select the Exchange Rates connector.
    To create the Exchange Rate connector, go to the URL for “Creating Custom Connector for Power Apps
  2. Type SEK “Swedish Krona” currency in the symbol field.

Embrace the Future of Finance with Power Automate!

Learn how Power Automate can automate currency exchange rate updates in Dynamics 365, offering you a glimpse into the future of finance. With AlphaBOLD, start your journey towards more efficient and error-free financial management today.

Request a Demo
this image shows Exchange Rates connector
  1. If we execute the flow, we will get a JSON response. Hence, to update the dynamics currency record, we would need to parse the JSON response
  2. Add another action and Select Parse JSON
this image shows dynamics currency record
  1. Select the Body that the Exchange Rate Connector supplied
  2. Click Generate from Sample
  3. Type the Response you got from the API (Exchange Rate Connector)
    {   “rates”: {     “SEK”: 9.3573926298   }, “base”: “USD”,           “date”: “2019-12-27” }
  4. The platform will create the Schema as highlighted in yellow above
  5. Add an action to define a variable and assign the value from the Exchange Rate to the variable
this image shows Exchange Rate variable
  1. Add another Action and select the Common Data Service, Update a record

Read more: Power Automate Desktop: Streamline Your Workflow

this image shows Common Data Service
  1. Type the Environment, Entity name and Record Identifier, and Exchange Rate as shown in the image below
this image shows Record Identifier
  1. Save the flow and click on Flow Checker.
  2. Before running the flow, let’s test the current exchange rate that was initially set to 9.39, as shown in Step 2
  3. 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

Read more: How to Use Power Automate to Enhance Power BI

this image shows Flow Checker
  1. Now, Test the flow
this image shows Test the flow
  1. As seen below, the flow was executed successfully

Lead with Innovation in Currency Exchange!

Is manual currency management holding you back? Step ahead with Power Automate and AlphaBOLD's innovative solutions for Dynamics 365. Transform your approach to currency exchange rates and lead your market with cutting-edge automation.

Request a Demo
this image shows flow executed successfully
  1. 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.
this image shows account exchange rate
  1. The flow will automatically run every 1 minute to update the exchange rate, which will only impact the newly created records and not the existing ones.
this image shows new created records

Conclusion

Conclusively, the Power Automate platform takes automation business processes to the next efficiency level. 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.

Explore Recent Blog Posts

Infographics show the 2021 MSUS Partner Award winner

Related Posts

Receive Updates on Youtube