Showing results for 
Search instead for 
Did you mean: 
Helper I
Helper I

Format values from Collection Table displayed in Data Table

I have a Collection which contsins a table

The content of the Collection is diplayed in a PowerApp Data Table Control

The format of the data does not display any formatting such as $ or , normally available in other controls using the Text( XXX,"$##,#") Formatting.

See Screen shots below


How do I format the content of a DataTable?Formatting PowerApp Data Table content.jpg


Frequent Visitor

Hi, Bherz - did you manage to get this done? I am facing the same issue. Even local collection is not working.


Just put ClearCollect() before your add column formula. 


AddColumns( collectionName, "SelectedRSFAvailable2", Text(SelectedRSFAvailable, "$##,#"), "TotalRSFAvailable2", Text(TotalRSFAvailable, "$##,#")) )

This will give a new collection with the added column. 

I hope it helps someone. 

Best Regards, 
Ali Nawaz

Helpful resources

New Badges

New Solution Badges!

Check out our new profile badges recognizing authored solutions!

New Power Super Users


We are excited to announce the Power Apps Super Users!

Power Apps Community Call

Power Apps Community Call: February

Did you miss the call? Check out the Power Apps Community Call here.

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

Top Solution Authors
Top Kudoed Authors
Users online (49,694)