hello I have a format problem between the list and powerapps.
the value is a calculated value in the list: ok
problem display in powerapps adds bcp of 0.
list = 2632.50
powerapps 2632.50000
how to display the correct value 2632.50 in powerapps.
the problem is only on calculated values of sharepoint lists.
Solved! Go to Solution.
My eyes are not what they used to be!! 🤓 I thought that was a period in the list image! Now I see it better.
Yes, that is the issue there. But instead of the substitute, I might suggest:
Value(ThisItem.PVU, "fr-FR")
Thanks @RandyHayes - I guess your eyes aren't what they used to be as you're spending too much time here!!
Thanks for the good suggestion - it's pretty clear what you're suggesting here, and I think this is what you meant 🙂
Value(ThisItem.PVU, "en")
Yes, way too much screen time these days!!
I'm not sure that the "en" is what is needed. The "fr-FR" should be it. Telling the Value function what the locale is will force it to convert it to the appropriate value based on the format.
If I do : Value("123,11", "fr-FR") I get 123.11
If I do: Value("123,11", "EN") I get 12311
Hi @RandyHayes
The way I see the problem is like this. The target runtime environment is French. Therefore, calling Value("123,11") would effectively be the same as Value("123,11", "fr-FR").
The complicated thing here is that Power Apps returns the SharePoint calculated field in English format. Because of this mismatch, it's necessary to specify Value("123.11", "en") to carry out the conversion.
My earlier hack basically converted the English format to French, which then enabled Value to work, without needing to specify an additional language code.
with
Value (ThisItem.PA; "fr-FR")
the display is blank.
Value ("2632.50"; "fr-FR")
= 2632.5