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

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
Super User
Super User

Re: Datatable number format

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

Re: Datatable number format

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
Super User
Super User

Re: Datatable number format

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

Re: Datatable number format

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

Super User
Super User

Re: Datatable number format

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

Re: Datatable number format

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

Re: Datatable number format

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
secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

firstImage

New Ranks and Rank Icons released on April 21!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power Apps Community!

Top Solution Authors
Top Kudoed Authors
Users online (8,144)