web

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

News and Announcements icon

Power Platform CommunityForums Power Apps GroupBy Multiple columns

Power Apps

Unanswered

GroupBy Multiple columns

(0) Share

Report

Report

Posted on by NathanFra

183

I am attempting to nest a GroupBy within itself because I'd like to take my entries from a SharePoint list and display them on a Power Apps line graph.

Current scenario is users go out to locations and swab items for bacteria for testing. They gather a reading (Number column) and log that depending on the Facility as well as which Department they were in.

Ideally I would like to get the average reading per each Facilities' Department.

Right now I'm using Single Line for my Facility and Department columns.

This is as far as I'm able to get with everything working. The current formula is my OnVisible for the screen.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

StalinPonnusamy Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Hi @NathanFra

We can use nested Group By Column like

AddColumns( GroupBy( Datasource, "Col1","col2","NewTableName" ), "NewcolumnName", Average(NewTableName,ColToaverage) )

Was this reply helpful? Yes No

Join the conversation