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

Formatting the look of excel data in power apps

I have an excel spreadsheet with extensive calculations being ran and it feeds into a report with several tables. Can a table like this be created and populated dynamically in powerapps? I know I can create a data table with this info. The problem is the merging of the Boring Numbers. Can you create a data table that merges 'like' data?




Super User
Super User


You cannot format a datatable this way but you could create a gallery/subgallery  and use the Groupby() function to merge records.

Thankyou. I will try that

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Carousel_PP_768x460_Wave2 (1).png

2022 Release Wave 2 Plan

Power Platform release plan for the 2022 release wave 2 describes all new features releasing from October 2022 through March 2023.

365 EduCon 768x460.png

Microsoft 365 EduCon

Join us for two optional days of workshops and a 3-day conference, you can choose from over 130 sessions in multiple tracks and 25 workshops.

Top Solution Authors
Users online (3,128)