Blog

Example - How to use a drop down control to convert currencies

For cases where we want to display values or prices in a different currency, this post describes a simple example of how to use a drop-down box to display the converted value.

This post walks through how to display an input value in a different currency by using a drop down control. The user can select a currency from the dropdown and the result will appear in a label.

This example caters mainly for organisations with standard Microsoft 365 licensing. For organisations with access to Dataverse, Dataverse includes built-in functionality that takes care of currency conversions.

Creating a table of exchange rates

The key thing that's required is a table of currency exchange rates. A good place to store this data is in a SharePoint list.

To support this, we can build some external processes to keep these values up to date. There is a good blog post by Ryan Maclean on how to do this with Power Automate and custom connectors.

https://ryanmaclean365.com/2020/02/13/exchange-rate-conversion-with-power-automate/

For this example, we'll create a collection that stores the exchange rate values using the formula beneath. This collection stores the exchange rate from US dollars. We can add this formula to the OnStart or OnVisible properties of the app or screen respectively.

ClearCollect(
     colExchangeRates,
     {
       Currency:"Euro",
       Rate:1.01423
     },
     {
       Currency:"British Pound",
       Rate:0.88539
     },
     {
       Currency:"Indian Rupee",
       Rate:80.908139
     },
     {
       Currency:"Australian Dollar",
       Rate:1.505248
     },
     {
       Currency:"Canadian Dollar",
       Rate:1.345757
     },
     {
       Currency:"Singapore Dollar",
       Rate:1.416514
     },
     {
       Currency:"Swiss Franc",
       Rate:0.978288
     },
     {
       Currency:"Malaysian Ringgit",
       Rate:4.566888
     },
     {
       Currency:"Japanese Yen",
       Rate:141.501547
     },
     {
       Currency:"Chinese Yuan Renminbi",
       Rate:7.061676
     }
)

Adding the currency drop down control to a form

From our app, we can then add a drop-down control (ddCurrency) and set the Items property to colExchangeRates.


Note that in this example, the form is a display form and therefore, we must set the display mode of the data card to make the drop-down control selectable for the user. The dropdown control will be disabled if we fail to do this.

Next, we can add a label and multiply the target value by the selected rate in the drop-down control like so:

ThisItem.AquisitionPrice * ddCurrency.Selected.Rate

We can also incorporate a call to the Text function to format the result more cleanly.


At runtime, the user can now use the dropdown to display the value in one of the available currencies.

Previous
Next
Related posts