I have 4 entities in CDM/Dynamics that each have a many to 1 relationship with the entity beneath it. So
A is at the Top with many B's below it and many C's below B and Many D's below C. In the GUI this looks like D has a lookup field to C and C has a lookup field to B and B has a lookup field to A.
My questions is how can I take that hierarchy and display it in a Hierarchical fashion. I have attempted this with nested Conccats but can't seem to get it correct and get invalid type error to often once I get into the second concat. Any ideas?
There are couple of ways to do that. One of the way is Add nested Galleries.
Let me elaborate on how to do that.
if this answers your question mark it as verified and give it a thumbsup
Pavan Kumar Garlapati
Hi @JohnBrown ,
Do you want to display 4 Hierarchy layout within your PowerApps app?
If you want to display 4 Hierarchy layout within your PowerApps app, I afraid that there is no way to achieve your needs in PowerApps.
Currently, within PowerApps, you could only create a 2 Hierarchy Gallery layout, in other words, you could add a nested gallery within a Main gallery, but you could not add another nested gallery within the above nested gallery (3 Hierarchy Gallery is not supported).
As an alternative solution, you could consider create 4 individual Gallery controls to achieve your needs. Each gallery control is corresponding to each Entity as below:
Set the Items property of the Gallery1 to follownig:
Set the Items property of the Gallery2 to following:
Filter('EntityB', LookUpField_BToA.'Primary Name' = Gallery1.Selected.'Primary Name')
Set the Items property of the Gallery3 to following:
Filter('EntityC', LookUpField_CToB.'Primary Name' = Gallery2.Selected.'Primary Name')
Set the Items property of the Gallery4 to following:
Filter('EntityD', LookUpField_DToC.'Primary Name' = Gallery3.Selected.'Primary Name')
Please consider take a try with above solution, then check if the issue is solved. On your side, you could select different items in your Gallery1, then the corresponding child Hierarchy would be shown up within Gallery2, Gallery3 and Gallery4.
Hi @JohnBrown ,
If you want to use Concat function to achieve your needs, I afraid that there is no easy way to achieve your needs. You may need to type multiple nested Concat function within your formula.
As an direct solution, I think the 4 Gallery controls may be the better choice for you.
Check it out!
Fill out a quick form to claim your user group badge now!
Find out where you can attend!
Features releasing from October 2019 through March 2020
The largest Power BI, Power Platform, and Data conference in New Zealand