Unanswered

Trouble with currency format and different browsers (Country settings..)

(0) Share

Report

Posted on by JMWilhelm

Hi there,

I'm having a hard time to display / calculate a proper € value from some data, that is stored in a dataverse table. In one browser (country setting) it displaies the expected value. In another browser (different country setting) it displays a complete nonsense value. I expect that it has something todo with the way the value is getting formatted ( 1.000.000,00 €)... Any suggestions?

THX in advance,

Jan

Text(
Sum(
Filter(
Angebot;
Year(Now()) = Year(ThisRecord.'Mandat Start') And (ThisRecord.'Angebot Status' = 'Angebot Status (Angebot)'.Beauftragt Or ThisRecord.'Angebot Status' = 'Angebot Status (Angebot)'.'Beendet (Erfolgreich)')
);
ThisRecord.'Tagessatz (€)' /* this is a currency value in dataverse*/ * ThisRecord.'Volumen Bestellt (Tage)' // This is only a dezimal value
);
"[$-de-DE]###.###.##0,00 €"
)

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (2)

Answers (0)

v-mengmli-msft on at

Like (0)

Report

Hi @JMWilhelm ,

I think this answer will help you. By the way, could you please show more details? For example, the country in which the other user is located and their number format.

Solved: Number Format . , - Power Platform Community (microsoft.com)

Best regards,

Rimmon

Was this reply helpful? Yes No
JMWilhelm 11 on at

Like (0)

Report

Hi @Rimmon,
thanks for your support. One browser is running DE (Germany) setting. The other browser is running in EN (US Setting).

Is there a way to force a power app to use a certain currency no matter what setting the browser is using?

thanks & kind regards,
Jan

Was this reply helpful? Yes No