Convert rows to columns in Power Apps

(0) Share

Report

Posted on by CU20081036-0

181

Hi Power Apps Community,

I have an app fetching data from data verse table and would like to convert rows to columns and find the sum of quantity.

Input Table

Expected output

tried achieving the expected result using group by. Could someone help accomplish above. Thanks

Categories:

Building Power Apps

I have the same question (0)

All responses (6)

Answers (1)

Suggested answer

Pacel1 79 on at

Like (1)

Report
I was tested this on my site, and below You have a working solution :)

ClearCollect( tempCollection, //Name of temp collection AddColumns( GroupBy( YourDataSet, //Reference to Your Collection Client, // First group Column Distributor, //Second group Column Month, //Third group Column Groupeddata //Column with grouped data -- ), SUM, //Name of newly added column where Your summed data will present Sum( ThisRecord.Groupeddata, Quantity ) ) )

Was this reply helpful? Yes No
ronaldwalcott 3,847 Super User 2025 Season 2 on at

Like (1)

Report

Do you just want to display the output or are you using the data for some other function as you could do this using Power BI?

Was this reply helpful? Yes No
Suggested answer

Daniel Bocklandt 5,099 Super User 2025 Season 2 on at

Like (1)

Report
Hey @CU20081036-0,

I have managed to do it like this (colTest is the Input Table):
ClearCollect( colInterm, AddColumns( colTest, ClientDistributor, Client & Distributor ) ); Clear(colResults); ClearCollect( colDistinct, Distinct( colInterm, ClientDistributor ) ); ForAll( colDistinct As X, With( { ClientValue: LookUp( colInterm, ClientDistributor = X.Value ) }, Collect( colResults, { Client: ClientValue.Client, Distributor: ClientValue.Distributor, Month: ClientValue.Month, Quantity: Sum( Filter( colInterm, ClientDistributor = X.Value ), Quantity ) } ) ) )

I don't know if it's the fastest way. Since this was my first attempt probably not but let me know it this works for you

If this solvede your porblem please accept it as solution so others can find it as well.
If it helped in any other way consider liking it so we can keep supporting eachother.

Was this reply helpful? Yes No
CU20081036-0 181 on at

Like (1)

Report

@Pacel1,

Thanks for the response. It works. How to convert column month to row like shown below. Thanks

Was this reply helpful? Yes No
Verified answer

Pacel1 79 on at

Like (0)

Report
Hi, You should try something simmilar to previous solution.

ClearCollect( testowa1, //Name of temp collection AddColumns( GroupBy( TempCollection1, //Reference to Your Collection Client, // First group Column Distributor, //Second group Column Groupeddata //Column with grouped data -- ), JAN, //Name of newly added column where Your summed data will present Sum(Filter(ThisRecord.Groupeddata, Month = "Jan"), Quantity ), FEB, //Name of newly added column where Your summed data will present Sum(Filter(ThisRecord.Groupeddata, Month = "Feb"), Quantity ), MAR, //Name of newly added column where Your summed data will present Sum(Filter(ThisRecord.Groupeddata, Month = "Mar"), Quantity ) ) )

If this solved your porblem please accept it as solution :)

Was this reply helpful? Yes No
CU20081036-0 181 on at

Like (0)

Report

@Pacel1,

I have run into an issue recently. Data that I'm after is present till AddColumns step, however, collecting it into collection fails with few records missing.

Any suggestions on the troubleshooting would be helpful. Thanks

Was this reply helpful? Yes No