cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BHerz
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

 

11 REPLIES 11
Swagato
Frequent Visitor

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

Anonymous
Not applicable

Hi, 

Just put ClearCollect() before your add column formula. 

Like, 

ClearCollect(NewlyCreatedCollection,
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

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Top Solution Authors
Top Kudoed Authors
Users online (2,531)