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

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

lreinhard7
Level 8

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
lreinhard7
Level 8

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

lreinhard7
Level 8

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

lreinhard7
Level 8

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (4,379)