Power Apps Exchange

I have a sharepoint list with some number field (money values) and a calculated column that adds/substrates values.
The column is type "number" and is defined with 2 decimal places.

and for "normal" number fields, this works fine (e.g. in "Approved budget" in screenshot above).
Any Idea on this? I want to show it as "50,000.00€"

------------------------------
Fabian Heil
IT Consultant SharePoint Applications
------------------------------

Hi @Fabian Heil,
SharePoint calculated fields are problematic at best in Power Apps.
Why not simply do the same calculation in Power Apps?​

------------------------------
Warren Belz
Queensland Australia
------------------------------

Original Message:
Sent: Jan 05, 2021 07:22 AM
From: Fabian Heil
Subject: Display Format of calculated column field

I have a sharepoint list with some number field (money values) and a calculated column that adds/substrates values.
The column is type "number" and is defined with 2 decimal places.

I show this value in a field in powerapps. But for any reason, it shows a lot of "0".

In the Text property, i have the following:

and for "normal" number fields, this works fine (e.g. in "Approved budget" in screenshot above).
Any Idea on this? I want to show it as "50,000.00€"

------------------------------
Fabian Heil
IT Consultant SharePoint Applications
------------------------------

Fabian,
In the old days I used an additional TEXT column with =TEXT([Field],"0.00") or similar.
This was helpful to overcome the annoying 1000 separator in the German zip codes :)

Did you look into column formatting with JSON? There are some good examples on Github.

Anyway, as Warren mentioned, why not calculate and format in Power Apps?


------------------------------
Peter Heffner
Intranet Solution Specialist III
------------------------------

Original Message:
Sent: Jan 05, 2021 07:22 AM
From: Fabian Heil
Subject: Display Format of calculated column field

I have a sharepoint list with some number field (money values) and a calculated column that adds/substrates values.
The column is type "number" and is defined with 2 decimal places.

I show this value in a field in powerapps. But for any reason, it shows a lot of "0".

In the Text property, i have the following:

and for "normal" number fields, this works fine (e.g. in "Approved budget" in screenshot above).
Any Idea on this? I want to show it as "50,000.00€"

------------------------------
Fabian Heil
IT Consultant SharePoint Applications
------------------------------

Fabian, just in case you want to go the JSON way: https://github.com/pnp/sp-dev-list-formatting/tree/master/column-samples

------------------------------
Peter Heffner
Intranet Solution Specialist III
------------------------------

Original Message:
Sent: Jan 05, 2021 07:22 AM
From: Fabian Heil
Subject: Display Format of calculated column field

I have a sharepoint list with some number field (money values) and a calculated column that adds/substrates values.
The column is type "number" and is defined with 2 decimal places.

I show this value in a field in powerapps. But for any reason, it shows a lot of "0".

In the Text property, i have the following:

and for "normal" number fields, this works fine (e.g. in "Approved budget" in screenshot above).
Any Idea on this? I want to show it as "50,000.00€"

------------------------------
Fabian Heil
IT Consultant SharePoint Applications
------------------------------