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
Solved! Go to 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
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
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.
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
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
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
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
User | Count |
---|---|
183 | |
123 | |
88 | |
45 | |
42 |
User | Count |
---|---|
254 | |
160 | |
126 | |
78 | |
73 |