Power Apps Exchange

Please login or click SIGN UP FOR FREE to create your PowerAppsUG account to join this user group.
Expand all | Collapse all

Display Format of calculated column field

  • 1.  Display Format of calculated column field

    Gold Contributor
    Posted Jan 05, 2021 07:23 AM
    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
    ------------------------------


  • 2.  RE: Display Format of calculated column field

    Top Contributor
    Posted Jan 19, 2021 06:23 AM
    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
    ------------------------------



  • 3.  RE: Display Format of calculated column field

    Gold Contributor
    Posted Jan 20, 2021 02:41 AM
    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
    ------------------------------



  • 4.  RE: Display Format of calculated column field

    Gold Contributor
    Posted Jan 20, 2021 02:49 AM
    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
    ------------------------------