Powerapp Calculation Eng Works - French Does Not

[smartin]

Hi everyone

Strangest thing going on my app. I have some text labels on screen in my app that work when the user is on a computer with the language is set to English. For my Quebec users with French computers...the labels just show blank. I'm bringing in the data from a SP list in case that's relevant. I've even tried a calculated column but then it brings in too many decimal points. The rounddown function doesn't work on french computers eithers. 

Example: Total Score for a test. Text for the label = First(TMDATA).TPOINTS*100 & "%" and it shows 69% on Eng. French...blank. 

It's like the *100 is doing something in the french language that I can't resolve. 

I've tried this too - works in english but nothing in french: Value(RoundDown(First(TMDATA).Load*100,1))

At my wits end...

[crisfervil]

@smartin Is it possible that the "First(TMDATA)" function is returning something different in French?

To debug this I would recommend finding where is the issue: In the data or the formula.

Try for example, removing the "First(TMDATA).TPOINTS" part from the formula and replace it with a fixed number

Also, set the "First(TMDATA).TPOINTS" value in a label, so, you can see its contents.

Remember that your Power App language is based on the browser's selected language, so you can use it to test. 

If it is a data problem, try to set up a test user with the same permissions as your French friends, so you make sure the data retrieved is the expected one. 

If you can't do that, you can use the PowerFx Trace function, and start a monitoring session with the users.

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-trace

I hope it helps!