Reformat column in collection contains value variables.

[IAmTheAppUser]

I have a column that has currency values.

There is a 'price' column in the collection and the values are in the format as 1234.33 and 13583.22 etc. I wan to reformat them as $1,234.33 and $13,583.22

I am aware of the formula Text( 1200000.00, "[$-en-US]$ #,###.00" ).

How do I apply this formula to whole column in the collection?

[mdevaney]

@IAmTheAppUser 

Well, there are a few ways we could tackle this.  From your problem statement I assume you need the formatted number column to appear in the price column and the original number type data should be deleted.  In that case use the code below.

ClearCollect(your_collection_name,
    RenameColumns(
        DropColumns(
            AddColumns(
                your_datasource_name,
                "priceFormatted",
                Text(price,"[$-en-US]$#,###.##")
            ),
        "price"),
    "priceFormatted",
    "price")
)

If you just want to add a column with the formatted text don't bother with the DROPCOLUMNS and RENAMECOLUMNS functions in my solution.  Finally, make sure you use this code when the collection is first created.  A column within a collection must have the same data type throughout the app.  It cannot have number types in one place and text in another.

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[IAmTheAppUser]

For some reason, the formula did not work.

It basically copy the same value again (I tested it with adding the value to another column).... That's the main reason that I encountered.

The formula works: Text( 1200000.00, "[$-en-US]$ #,###.00" ) - if we specify the number in the formula. The formula seems not able to adjust the number in the collection. The only thing I am able to do is to add a '$' symbol before the figure. Not adjust anything in between the number. Do you have any idea how to get pass this issue?

[v-monli-msft]

Hi @IAmTheAppUser ,

Check on below thread to see if it could help:

https://powerusers.microsoft.com/t5/Building-Power-Apps-Formerly/Format-values-from-Collection-Table...

Regards,

Mona