web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps Formula to be used in ...

Power Apps

Unanswered

Formula to be used in Items of a Gallery

(1) Share

Report

Report

Posted on by Sam70

271

Hi,

Below is the Data Structure of a SharePoint List

Parameter	Unit of Measurement	Figures	Period
Headcount Details	Number	20	November
Headcount Details	Number	2	November
Headcount Details	Number	4	November
Headcount Details	Number	10	November
Test-1	Number	5	November
Test-11	WS	10	November
Test-11	WS	20	November
Headcount Details	Number	5	December
Headcount Details	Number	20	December
Headcount Details	Number	13	December
Headcount Details	Number	14	December
Headcount Details	Number	15	December

Kindly help me with a formula, which will get me the result in a gallery as below

Parameter	Unit of Measurement	November	December
Headcount Details	Number	20	5
Headcount Details	Number	2	20
Headcount Details	Number	4	13
Headcount Details	Number	10	14
Test-1	Number	5	15
Test-11	WS	10
Test-11	WS	20

Regards

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

WarrenBelz 152,865 Most Valuable Professional on at

Like (0)

Report
Hi @Sam70

I am a little confused on the criteria for that you have applied for the summary, however you cannot create column names dynamically, so your exact layout is not possible. If you want a Month summary, you can do this
AddColumns( GroupBy( SPList, Parameter, 'Unit of Measurement' Period, Grouped ), MonthTotal, Sum(Grouped,Figures) )

Please click Does this answer your question if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it a Like.
MVP (Business Applications) Visit my blog Practical Power Apps LinkedIn Buy me a coffee

Was this reply helpful? Yes No

Sam70

271 on at

Like (0)

Report

Report

Hi @WarrenBelz,

My apologies for listing common Parameters earlier. Below is the updated List.

Parameter	Unit of Measurement	Figures	Period
Headcount Details-1	Number	20	November
Headcount Details-2	Number	2	November
Headcount Details-3	Number	4	November
Headcount Details-4	Number	10	November
Test-1	Number	5	November
Test-11	WS	10	November
Test-11	WS	20	November
Headcount Details-1	Number	5	December
Headcount Details-2	Number	20	December
Headcount Details-3	Number	13	December
Headcount Details-4	Number	14	December
Headcount Details-5	Number	15	December

Based on the above i need a function to generate below output in a Gallery. And November and December columns are fixed.

Parameter	Unit of Measurement	November	December
Headcount Details-1	Number	20	5
Headcount Details-2	Number	2	20
Headcount Details-3	Number	4	13
Headcount Details-4	Number	10	14
Headcount Details-5	Number		15
Test-1	Number	5
Test-11	WS	10
Test-11	WS	20

Regards

Was this reply helpful? Yes No

timl 36,328 Super User 2025 Season 2 on at

Like (1)

Report

Hi Sam70

Just to add to this, Warren is correct - it's not possible to create column names dynamically.

You might be interested in this idea that I posted in the Ideas forum, which would help you transform your Period > November and December values to column headers.

https://ideas.powerapps.com/d365community/idea/2b61ad52-7f54-4bda-b334-aed82eaaafe8

Was this reply helpful? Yes No
Verified answer

timl 36,328 Super User 2025 Season 2 on at

Like (2)

Report
Hi Sam70

Based on your updated data and given that the November and December columns will be fixed, this is the formula that creates a colGroupedTransposedData collection with your required output.

ClearCollect( colTransposedData, ForAll( YourSourceSharePointList As Data, { Parameter: Data[@Parameter], UnitOfMeasurement: Data[@UnitOfMeasurement], November: If(Data[@Period] = "November", Data[@Figures], Blank()), December: If(Data[@Period] = "December", Data[@Figures], Blank()) } ) ); ClearCollect( colGroupedTransposedData, AddColumns( GroupBy( colTransposedData, Parameter, GroupedItems ), UnitOfMeasurement, First(GroupedItems).UnitOfMeasurement, November, Sum(GroupedItems, November), December, Sum(GroupedItems, December) ) );

I tested this with your data and it gives the correct output.

Was this reply helpful? Yes No

Join the conversation