web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Relate and Unrelate ar...
Power Apps
Answered

Relate and Unrelate arent working with 1:n relationship

(0) ShareShare
ReportReport
Posted on by 8

I have a canvas app in which I handle some Data about Clients primarily their emails.
I have a Dataverse Table where the emails are stored and a Dataverse Table where the Information for the emails are stored (Surname, name, pronouns). Since one person can have many emails it is a 1:n relation between the two. There is a lookup table created in the email table.
Also when I relate/unrelate with a m:n relationship everything works smoothly.

However if I relate/unrelate with a 1:n relationship it always gives me the same error, but only after i give the 2nd argument.
"The first argument has to be a table that is :n related" rough translation from german there.

In this example I name the tables: Emailtable (n), Person(1)
Emailtable is in gallery 1 and Person is thisitem
Relate(Gallery1.Selected.Emailtable; ThisItem)
I also tried 20 different versions with lookups and such but nothing to get it to work.
As i said it works perfectly fine with m:n relationships and the documentation suggests it should work here aswell.
Is there something obvious I am missing?

Thanks in advance for help
Can Kaymaz

Categories:
  • Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @CanKaymaz 

    Have you created the relationship between clients and emails on your dataverse table?_8.jpg

  • CanKaymaz Profile Picture
    8 on at

    Yes, as I said the lookup column has been added, which was done automatically after i created the relationship.

  • Verified answer
    Drrickryp Profile Picture
    Super User 2024 Season 1 on at

    @CanKaymaz 

    Check out this documentation of the Many to One relationship for how to accomplish your goal.

    https://powerapps.microsoft.com/en-us/blog/one-to-many-relationships-for-canvas-apps/ 

  • CanKaymaz Profile Picture
    8 on at

    Okay, so everything is working, except for the Relate and Unrelate functions. I can add relationships with the patch function, however i cant remove them. I have no problems referencing the related objects, except for these 2 functions.

  • CanKaymaz Profile Picture
    8 on at

    So i somehow fixed it by turning the operation around. I am not sure if this is how its supposed to work, but i take it

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 397 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 354

#3
WarrenBelz Profile Picture

WarrenBelz 232 Most Valuable Professional

Last 30 days Overall leaderboard