Datatable number format

[lreinhard7]

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. 

The field is actually formatted as a text

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

Has anybody an idea about this issue?

Best regards, 

Ludwig

[Shanescows]

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. 

[lreinhard7]

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

[Shanescows · Accepted solution]

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

[lreinhard7]

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

[lreinhard7 · Accepted solution]

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