web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / I see text in my DataC...
Power Apps
Answered

I see text in my DataCard But my SharePoint list has financial setup. How can I see the financal in the view of my form

(0) ShareShare
ReportReport
Posted on by 86

Hello 
I'm just a PowerApps beginner so I've some questions where I hoop you can help me a bit. 

I created a simple PowerApp from a SharePoint List.

In this list there is a column with a calculate field. this returns in a fanacial value eg.  € 350.

In my PowerApps data card in the Viewform I see  350.0000000000000
What I can find out that it is there a simple text and not a fainacial proporty. 
But How can I solve this?

 

Regards 
Steven van der Bles 
Netherlands

Categories:
  • eka24 Profile Picture
    20,925 on at

    Try

    Round (Datacaradvalue4,2)

    Change Datacaradvalue4 to your Textbox name or Datacaradvalue name

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • Steven | TIMI365 Profile Picture
    86 on at

    Sorry that didn't work ......
    Thanks for helpin'

  • eka24 Profile Picture
    20,925 on at

    Try

    Text(Parent.Default,"[$-en-US]£#,###.00")

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

  • Steven | TIMI365 Profile Picture
    86 on at

    Thanks

     

    I changed it and have no error message or so. Bur in my field I still see the same 

    " 350.0000000000000 "

    But thanks again.

  • eka24 Profile Picture
    20,925 on at

    Change the Format property of the textbox or datacardvalue  from Number

     

    Also try
    Text(Value(Parent.Default),"[$-en-US]£#,###.00")

     

    if you still have issues show a screen shot

    ------------

    If you like this post, give a Thumbs up. Where it solved your request, Mark it as a Solution to enable other users find it.

     

  • Steven | TIMI365 Profile Picture
    86 on at

    In de Power shot you see it's stil not working. 

    Of course we are in Europa and the currancy is Euro. But that should not bring the mistake because fot now it is OK when i have it in $. 
    Sorry for the dutch language. The word 'Omzet' means 'turnover' and yes I would like it to see as euro's. Like i have it in the SharePoint list.

     

    Thanks for helpin.

     

    Kind regards 

     

    Steven

    Screenshot PowerApps.jpg
  • v-siky-msft Profile Picture
    Microsoft Employee on at

    Hi @StevenTIMI263 ,

     

    The calculated field is taken as Text type, you need to convert it to Number first by Value() function as @eka24  mentioned, then use Text() function to display as currency.

    Text(Value(Parent.Default),"€#,###.00")

    Snipaste_2020-07-27_16-37-03.png

    Hope this helps.

    Sik 

  • Steven | TIMI365 Profile Picture
    86 on at

    Hi Sik,

     

    Thanks for your help,

    I changed it and, maybe even more importand, I understand your steps. 

    After the change I didn't had error messages ...
    But.......

    The Value is not € 300,00  but € 300.000.000.000.000.000. (see screenshot)

     

    And thats not good 

     

    Any idea? 

     

    Ialso consider another approach. I now calculate in the SharePoint list. 
    Maybe it is better to calculate in the PowerApp and then send the value to the list. I'm to much a beginner to know what is the best approach here. Anycomments on that?

     

    Regards

     

    Steven 

    power apps error.jpg
  • Verified answer
    v-siky-msft Profile Picture
    Microsoft Employee on at

    Hi @StevenTIMI263 ,

     

    This issue is due to the difference in the delimiters between countries. I have reproduced your issue, please try with this workaround, i believe it can work for your case. First to convert the text to value in en-us format, then format it to Currency in nl format.

    Text(Value(Parent.Default,"en-US"),"[$-nl]€#.###,00","nl")

     

    Both solutions should work, the pros and cons are that calculated columns trigger automatically if changed, whereas PowerApps way need to manually trigger each time the data is submitted.

     

    Hope this helps.

    Sik

  • Steven | TIMI365 Profile Picture
    86 on at

    YEAH

     

    Solved

     I had to do one more thing and that was to change the delimiter fro " , " to " ; " . But that was easy. 

    Thanks.

     

    Steven

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 236 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 207 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 169

Last 30 days Overall leaderboard