web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Group by (lookup field...
Power Apps
Answered

Group by (lookup field) and use on multiple fields.

(0) ShareShare
ReportReport
Posted on by 52
Hi All, 
 
I have created a application (model driven app) for workorders and have the following tables:
 
  • Project
  • Project Phase
  • Workorder
 
 
I would like to create a view that shows all the workorders grouped by Project and Project Phase.
 
I have created a view with the "Power Apps Grid Control" Compontent, I am able to group by the workorder but i cannot group by the lookup fields. Next to that you can only group by one colomn but preferably i would like to group by multiple colomns like so:
 
Project (lookup) Project Phase (lookup) Workorder
Project 1 Phase 1 Wo-1
   
Wo-2
  Phase 2 Wo-3
    Wo-4
Project 2 Phase 3 Wo-5
     
     
 
 
I know you can create a nested view with a subgrid but as far as i know you cannot do that for multiple relations. Any ideas to solve this? The only option i can think of is creating a pcf component or canvas app and embed it into the application. I hope there is or will be a native function for this. 
 
Kind regards, 
Arjan
 
Categories:
I have the same question (0)
  • Verified answer
    MS.Ragavendar Profile Picture
    6,274 Super User 2026 Season 1 on at
    Power Apps Grid Control currently has limitations in grouping lookup fields and supporting multi-level grouping.
     
    Approach 1 - Calculated Column
    • Calculated Column in the Workorder Table.
    • Concatenate the Project Name and Phase Name.
    • Use This Column for Grouping.
    Approach 2 - Custom Component PCF
     
    Approach 3 - Canvas App with Nested Galleries
    • Level 1 - Display distinct Projects.
    • Level 2 - Filters by Project and displays Phases.
    • Level 3 (Inside 2) - Workorders for the selected Project & Phase.
    Approach 4 - Power BI
    • If you need it only for visualization you can use the Power BI grouped by Project and Phase you can use Table or Matrix.
    • Simple and Straight Forward.
     
     
     
     
     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 493 Most Valuable Professional

#2
11manish Profile Picture

11manish 479

#3
Haque Profile Picture

Haque 328

Last 30 days Overall leaderboard