cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Stephen1606
Frequent Visitor

Multi Level Org Chart

Hi, 

 

I'm hoping someone might be able to help me create a multi-level org chart. I've created what I want to achieve in PowerPoint (image below).visualPath.pngThe columns in the datasource are Name, ID and Parent ID (PID), with the PID telling me where I need to branch off at. 

 

I tried nesting a gallery within another gallery and that seemed to get me along the right lines but I was only able to nest two galleries. 

 

Is this possible in PowerApps? I always say anything is possible, but I'm really struggling with ideas. Any help would be greatly appreciated. 

 

Thank you!

1 ACCEPTED SOLUTION

Accepted Solutions
Anonymous
Not applicable

closing this thread as it is a duplicate. 

 

@Anonymous 

View solution in original post

3 REPLIES 3
RandyHayes
Super User
Super User

@Stephen1606 

Oof!!

IMHO - That's going to be a hard one to put together in PowerApps!

You could do this in one horizontal gallery with an internal vertical gallery.

Challenges are:

1) Some what easy - You would really need (to try and make it easier) a "generation" for your data.  This way you can at least group the items by their generation and sort in the order of the generation line.

2) Super challenge - lines from one level to the next will be VERY difficult to produce. Defining lines that are coordinated to rows within a gallery are going to be tough because there is no idea what row you are in within a gallery.  Although you could turn on and off "pre defined" lines from cell to cell (and you would have to do that with some calculation within each generation), it would be unreliable to assume you could match it properly from another generation.  Consider your final Great-Great Grandchild 1...if the PID of that was 633, you would need that on the second row.  That would involve some complexity in the items for the internal vertical gallery.

 

Not saying this can't be done, just saying that it's going to be a big challenge to do.

Possible alternatives - Image:

1) Find an online resource that can generate an Image like this from a set of data, then connect to that as an image in your App

2) Create the org chart as an image in another tool and store it to be used within your app as an image.  You would have to update as needed.

 

Perhaps some others on here will chip in some ideas, but this is my experience with PowerApps.

I hope it is helpful for you.

_____________________________________________________________________________________
Digging it? - Click on the Thumbs Up below. Solved your problem? - Click on Accept as Solution below. Others seeking the same answers will be happy you did.
Check out my PowerApps Videos too! And, follow me on Twitter @RandyHayes

Really want to show your appreciation? Buy Me A Cup Of Coffee!
v-yuxima-msft
Community Support
Community Support
Anonymous
Not applicable

closing this thread as it is a duplicate. 

 

@Anonymous 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,444)