Calculated field from SP list not shown in desired format

[Anonymous]

Dear community,

I am really frustrated by an issue i got with a calculated field coming from a SP list and so far i could not solve it.

The column on the very right is beeing calculated (the formula is in the screenshot below). As you can see the values of the shown columns have the same format "#,##0.00". An excel export of the list confirms that.

In the next step I want to show the values of the 4 columns above in my Power App with following formula

...and what i get is that (s. below). The value should equal 10.576 (which can be found in the SP list itself and excel export), however the calculated field returns a value with distorted separator.

So far I have tried several TEXT and VALUE combinations but nothing worked out. I really appreaciate any help!

Thanks, James.

[Anonymous]

@Anonymous 

Try wrapping the column in the Value function, ie

Text( Value(ThisItem.Abgrenzungswert);"[$-de-DE]#.###")

Reference from @timl's blog:

http://powerappsguide.com/blog/post/sharepoint-beware-of-calculated-columns

[Anonymous]

Dear Eelman,

thank you very much. I have tried it but it still does not seem to have worked. :S

[Anonymous]

@Anonymous 

Calculated columns cause all sorts of problems in PowerApps, they should only be used in SharePoint and not in an app. The only other option I can think of is to use the same formula 'inside' your app as that used in your SP column.

This feels like a double up but should work. 

[Anonymous]

...I don't really know why but with the language "en-US" in the Value formula works now.

However the sum of the gallery is still wrong, here is the formula

Thanks!

[Anonymous]

@Anonymous 

That is strange, however one worth writing done for future reference. 

Re: your Sum() issue, how many records are in your List? Sum and Value don't work correctly on lists larger than 2000 records.