Unanswered

Problem when trying to create a 1-N hierarchy

(0) Share

Report

Posted on by Mango_Loco

So I have this weird problem that when I am trying to create a hierarchical 1-N relationship from a table to itself (in my example my table is MyCompany and the relationship would be subcompany) the relationship flips to N-1 for some reason. I am pretty sure that I am doing everything right and before saving everything looks correct. But after saving is done I always get the relationship flipped for some reason. Pretty hard to use hierarchy functions and logic when I can't even make the relationship in the first place 🤔

Does anyone know why this is happening? Would really appreciate if someone knows how to fix this, because without hierarchy I will have to do some really ugly gymnastics to make the app work as intended 😓

Categories:

Building Power Apps

All responses (2)

Answers (0)

Sort by

Drrickryp Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Mango_Loco

The typical way to do this would be with a second table of subcompanies linked in a One to Many relationships with company. Another way to do this would be to create a collection of subcompanies using Collect(subcomp, Distinct(MyCompany, subcompany)), and use subcomp as the items property of a dropdown in a form.
Mango_Loco 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @Drrickryp
Yeah, I was going to use a second table for subcompanies if I can't get hierarchy to work. The problem in that is that all companies should be able to have subcompanies and users should see subcompanies depending on what kind of role they have in the app. So a user might need to see companies in multiple layers. Companies are also something that will be added later, so I can't really know how many layers the app will have for example next year.

With 1-N hierarchy I should be able to pretty much just use Under function and that would do everything without any hassle no matter how many layers will be added later. So for that reason I would like to know why 1-N relationships in my tables are rotating constantly 😫