cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Kudo Kingpin
Kudo Kingpin

Changing CDS Default Currency

I posted an idea here

https://powerusers.microsoft.com/t5/Power-Apps-Ideas/Changing-CDS-Default-Currency/idi-p/355423

 

It says: -

 

After CDS data has been created in an environment, you cannot change the currency of the CDS data. If you need to change the currency, you need to delete the environment, recreate it from scratch and pick up the currency you wish.

 

With data being used and growing, this process may take you a month or 2 to complete, properly!

 

It may be hard, critical at the back-end to change the currency of the CDS data, but it is not impossible, nothing impossible I guess. I suggest that admins are allowed to change the currency of a CDS data from within the environment CDS settings, at least once. 

 

It is totally unfair that I need to create a new environment to be able to change default currency. Even Twitter/Facebook allows verified accounts change their name, once may be. Allow us change currency once, please. 

2 REPLIES 2
Highlighted
Community Support
Community Support

Re: Changing CDS Default Currency

Hi @Yahya ,

 

PowerApps supports the multicurrency system, each record can be associated with its own currency regard to a single currency, by using an exchange rate. That is known as the base currency. However, after the base currency is set, it can't be changed any more.

Although this is by design, I will submit your idea to the Team.

 

Best regards,

Sik 

Highlighted
Solution Supplier
Solution Supplier

Re: Changing CDS Default Currency

As per the previous post, it is a change to the base currency that requires a new environment. This is because CDS converts all currency values to the base currency, and stores them in _base fields. 

The main use for the base currency is to allow useful reports across currency values by using the _base fields. If you don't use this, there is no need to change the base currency. Even if you do want tot report across currency values, there are 2 other options that don't require a new environment:

  • Apply exchange rates in your report, working off the originating currency fields, which you could do with SSRS or PowerBI. This has an advantage, in that you get more control over when to apply exchange rates
  • Apply exchange rates in your report, working off the base currency, but just apply an exchange rate to convert it to whatever currency you want.

Helpful resources

Announcements
secondImage

New Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

August 2020 CYST Challenge

Check out the winners of the recent 'Can You Solve These?' community challenge!

Experience what’s next for Power Apps

Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.

Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Users online (4,745)