Unanswered

Calculated field from SP list not shown in desired format

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

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.

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Community Power Pla... Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
@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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Dear Eelman,

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

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

...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!

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

@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.

Was this reply helpful? Yes No