cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ben-00-38
Resolver I
Resolver I

display calculated value on powerapps.

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.

 

a1.png

a2.png

a3.png

14 REPLIES 14
RandyHayes
Super User
Super User

@timl 

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")

 

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
timl
Super User
Super User

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")

 

RandyHayes
Super User
Super User

@timl 

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

 

 

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
NOTE: My normal response times will be Mon to Fri from 1 PM to 10 PM UTC (and lots of other times too!)
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
timl
Super User
Super User

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

Helpful resources

Announcements
Power Apps Africa Challenge 2022

Power Apps Africa Challenge

Your chance to join an engaging competition of Power Platform enthusiasts.

Super User 2 - 2022 Congratulations

Welcome Super Users

The Super User program for 2022 - Season 2 has kicked off!

September Events 2022

Check out all of these events

Attend in person or online, there are incredible conferences and events happening all throughout the month of September.

Government Carousel

New forum: GCC, GCCH, DoD - Federal App Makers (FAM)

In response to the unique and evolving requirements of the United States public sector, Microsoft has created Power Apps US Government.

Users online (2,187)