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
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:
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 🙂
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
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.
This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.