web

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

News and Announcements icon

Power Platform CommunityForums Power Apps Create Hierarchical or...

Power Apps

Unanswered

Create Hierarchical organization chart

(0) Share

Report

Report

Posted on by adelev125

7

Hi All,

I'd like to create a hierarchical expandable organization chart by using excel file like below.

What I want to create is like below organization chart.

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

rubin_boer 4,843 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
hi @adelev125

Please have a look at the following for some direction (the sort answer is use a Power BI tile :)) but we don't all have the luxury right.

Your dataset actually allow you to get away with a gallery.

I will add a column to your data to check whether the line item is a parent (does it have any children attached to it)

//creating all the parentid in one string UpdateContext( { ChildStructure: Concat( cHierarc, OrgParentID, "," ) } ); //return a boolen if the item does have a child ClearCollect( cHierarc2, AddColumns( cHierarc, "HaveChild", OrgID in ChildStructure ) )

The result is something like this (we will use this to hide/show the icon to expand) :

Now for the final product, this is possible because you have the sort order and level

Add a gallery and set its datasourcce to the collection above, the one that checks for children

Add a icon (>) and set its visible = ThisItem.HaveChild

Set the icon X = ThisItem.Level * 25

Add a label and set its Text = Thisitem.YourOgName

Set the label X = icon.X + 30

This is the result:

Hope this helps,

R

Was this reply helpful? Yes No

Join the conversation