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

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Canvas apps Group Data...
Power Apps
Unanswered

Canvas apps Group Data using related table data in the Gallery Control

(0) ShareShare
ReportReport
Posted on by 86

Hi All,

 

I am using data verse tables in canvas apps. I have 'Entity A' which has a lookup of 'Entity B'  and

'Entity B' which has a lookup of 'Entity C'. 

I want to display the data in my gallery control grouped by 'Entity C' lookup

The Items property of my gallery control is set to 'Entity A'. How can i get the 'Entity C' Column in the Gallery and apply grouping based on it.

 

Kindly suggest.

I have the same question (0)
  • berofeev Profile Picture
    65 on at

    Hi @Poweruser1101,

     

    I would suggest you do something like:

     

    ClearCollect(AddColumns('Entity A', "ColumnName", Lookup('Entity C', entitycid=Lookup('Entity B', entitybid=[@'Entity A'].'Entity B'.entitybid).entitycid).Name))

     

    Thst syntax is probably not correct, but it gives you a rough idea on how to do it. 

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

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 796 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 327 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard