Hierarchical data display in Powerapps.

(0) Share

Report

Posted on by RoopaPendyala Microsoft Employee

Hi,

I have a requirement to display data in hierarchical manner.Something like below.

Group 1

SubGroup1

SubGroup2

Group 2

SubGroup1

Whats the best way to implement this in PowerApps as there is no treeview control.Thanks.

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Mike8 1,330 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello RoopaPendyala,

For your example you can use two Galleries. The first gallery will display the groups kai according on which group you select in the first gallery the second gallery will display the corresponding subgroups.
I don't know if it is the best way but it works for me.. 🙂
RoopaPendyala Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

Hi Mike,

can you paste sample code here ? Thanks.
Mike8 1,330 on at

Like
a
(0)

Report
Copy link

Link copied!

Hello,

Button1.OnSelect = ClearCollect(GroupCollection,{ID:1,text:"Group1"},{ID:2,text:"Group2"});
ClearCollect(SubgroupCollection,{ID:1,text:"Subgroup1",ParentID:1},{ID:2,text:"Subgroup2",ParentID:1},{ID:3,text:"Subgroup1",ParentID:2})

Gallery1.Items = GroupCollection
Gallery2.Items = Filter(SubgroupCollection,ParentID=Gallery1.Selected.ID)
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @RoopaPendyala,

Could you please share a bit more about your data source? Is it a SP list?

I created a SP list on my side, the data structure of it as below:

Note: The GroupName column and Parent Group column are both Single line of text type column in my SP list. The Parent Group column determine if a Group hierarchical has a parent group.

I have made a test on my side, please take a try with the following workaround:

Set the Items property of the Gallery1 (Parent Gallery) to following formula:

Filter('20180830_case7',Parent_x0020_Group=Blank())

Within the Gallery1, add a Label control, set Text property of it to following formula:

ThisItem.GroupName

Within the Gallery1, add another Gallery control (Gallery2, Child Gallery), set the Items property of the Gallery2 control to following formula:

Filter('20180830_case7',Parent_x0020_Group=ThisItem.GroupName)

Within Gallery2 control, add a Label control, set Text property of it to following formula:

ThisItem.GroupName

Note: The '20180830_case7' represents the SP list data source within my app.

The GIF screenshot as below:

Best regards,

Kris