Convert Prices Between 31 Common Currencies in Power Automate

To programmatically convert prices between different currencies, the first thing we to do is find a currency API that updates in real time with market exchange rate information.

Finding & calling a currency API might sound like something that requires writing a lot of code, but thankfully, we can do it with zero code (and in a matter of minutes) via Power Automate.

Converting prices between currencies in Power Automate

In Power Automate, we can use the Cloudmersive Currency API connector for free & exchange input prices between 31 global currencies.

After we make our currency conversions with a float or integer input (e.g., 20.34), we’ll return a price formatted according to destination currency conventions (e.g., “£16.58” for Pound Sterling, or “225,10 kr” for Swedish Krona).

Walking through an example flow

Below, we’ll walk through a quick example flow that uses the Cloudmersive Currency connector to convert a price from USD (US Dollar) to all 31 prices supported by the Currency API.

We’ll create a manually triggered Instant cloud flow in this context.

To start, we’ll add an action & search for Cloudmersive connectors. This brings up several Cloudmersive connector options; we’re looking for the Currency connector with the light green/teel logo.

We’ll see all three available actions in the actions list preview, including the Converts a price action we’ll eventually be using.

Enumerate available currencies & currency codes

Before we get to our price conversion action, we’ll start by selecting the Get a list of available currencies and corresponding countries action.

This action retrieves information about each currency supported by the Cloudmersive Currency API, including three-letter currency codes we can use to make price conversions. It’s not strictly necessary to use this API, but it’s a great way to see the full scope of the Currency API capabilities in one go.

Once we create our Currency connection, we’ll see the empty Parameters window shown in the screenshot above (this API performs a simple get request).

Create a Cloudmersive Currency API connection

To create a Cloudmersive Currency connection, we’ll need to get a free API key by visiting the Cloudmersive website & creating a free account. This will allow up to 800 API calls/month with no commitments (it’s the same tier of API key I’m using in this walkthrough).

Convert Prices

To make a price conversion, we’ll head back to the Currency connector actions list preview & select the Converts a price from the source currency to the destination currency action.

To configure our request, we’ll enter our three-digit source currency code in the source currency parameter (in this case, “USD”), and we’ll enter the ISOCurrencyCode value from our Get a list of available currencies action in the destination currency parameter.

Note that Power Automate instantly wraps our Converts a price action in a For each control, ensuring the price we enter will convert to all 31 available currencies (this will include one duplicate conversion between USD and USD).

We will now enter an input price. This can be any number we want; we’ll choose “20.53” in this example.

Execute the price conversion flow

At this point, we’ll save and test our flow.

When our flow finishes running, we’ll find our input USD price converted to 30 unique price values based (31 including the redundant USD conversion) based on up-to-date exchange rate information.

Review the outputs

If we click on our 1st For each run, we’ll find information for a USD to EUR (Euro) conversion in our Input.

In our Output, we’ll find a response object containing the full converted price value, the destination currency ISO code, the destination currency symbol, and the formatted price string.

In any flow where we convert prices using the Cloudmersive Currency API connector, we can parse each field of data seen here in our response object for downstream actions.

We can send automated Email, MS Teams or Slack messages with this information, or we can write our responses to a database to build our own price conversion tracker.

Conclusion

In this article, we learned how to convert prices between 31 common global currencies using the Cloudmersive Currency API connector in Power Automate. In this case, we converted one USD price to 30 other currency price values using up-to-date exchange rate information.

Be sure to follow this blog for more Cloudmersive API use cases in Power Automate and beyond!