cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted

Datatable number format

Hi, 

I have a PowerApp that takes all values from a SharePoint list. 

Everything works fine but the number that I get for a calculated field in SharePoint looks not exactly the way how I want it to look like. 

Here is how it looks like in my datatable. 

As you can see the amount has a lot of decimal places. 

mthlypayment1.png

 

The field is actually formatted as a text

mthlypayment2.png

 

I already tried formatting it as a value, which did, however, not help. 

 

Has anybody an idea about this issue?

 

Best regards, 

 

Ludwig

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted

Walking out the door but...

 

The quick answer is use Collect(NameOfCollection, SharePointListConnection) that will copy everything 1 for 1. You might have to mess around with ForAll to change the Column but not sure. Let me know if this doesn't get you moving in the right direction.

 


Shane

 

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

View solution in original post

Highlighted

Hi,

I got it mate.

The tip with the collection did the trick.

Simply added some columns to the collections.

When doing that, I could add the formats I like and everything works like a charm now.

Many thanks and have a great weekend.

Cheers,

Ludwig

View solution in original post

5 REPLIES 5
Highlighted
Super User
Super User

Ludwig - You want to use the Text function. But, I am not sure that you can do that in the context of a Data Table or with a Calculated Column. I did some quick testing and while the syntax works if I added a calculated column to the mix it did not for me. 

 

So what you might need to do is put the data into a collection, manipulate it in the collection, and then display it in your data table. 

 

TextFunction.PNG

 

 

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training
Highlighted

Hello Shane,

Many thanks for that.

Yet, how can I add all values from my SharePoint list automatically to a collection.

This is something I currently do not know.

Do you have some hints for me?

Best regards,

Ludwig

Highlighted

Walking out the door but...

 

The quick answer is use Collect(NameOfCollection, SharePointListConnection) that will copy everything 1 for 1. You might have to mess around with ForAll to change the Column but not sure. Let me know if this doesn't get you moving in the right direction.

 


Shane

 

Shane - Microsoft MVP, YouTube, and PowerApps Consulting for when you are in a bind to get this fixed quickly. And finally we now have PowerApps Training

View solution in original post

Highlighted

Hello Shane,

The collection tip is great. I got the data in my collection and can create a data table out of it.

Yet, how can I manipulate the data in my data collection?

I want to format for example the interest rate as % and the AnnuityInfo in $-terms, such as $123.45

How can I do that?

Best regards,

Ludwig

coll1.png

Highlighted

Hi,

I got it mate.

The tip with the collection did the trick.

Simply added some columns to the collections.

When doing that, I could add the formats I like and everything works like a charm now.

Many thanks and have a great weekend.

Cheers,

Ludwig

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (7,517)