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.
Your chance to join an engaging competition of Power Platform enthusiasts.
The Super User program for 2022 - Season 2 has kicked off!
Attend in person or online, there are incredible conferences and events happening all throughout the month of September.
In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.