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.

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are Your Ready?

Test your skills now with the Cloud Skill Challenge.

Top Solution Authors
Top Kudoed Authors
Users online (65,067)