I am having issues with the Relate function, and can't figure out where I am going wrong. I don't have any trouble when using a N:N relationship, but can't get N:1 to work.
I have a Meeting table and an Organization table, with a Many to One relationship between them. Each Organization can be related to multiple Meetings.
In PowerApps I am trying to connect a selected Meeting with a selected Organization, but am getting an error on my Relate formula "The first argument of Relate or Unrelate must refer to a 'to many' relationship"
My Relate is as follows
Relate(ComboBox4.Selected.ConnectedOrganization, ComboBox5.Selected)
Solved! Go to Solution.
Hi @jawalley
your syntax should be like this..
In this case relationship is from Account -> TempEntity (one to Many), meaning one account can have multiple child temp entity records
Relate(Dropdown1.Selected.TempEntities,Dropdown2.Selected)
(dropdown 1 is list account and dropdown 2 is list of temp entity records)..
for more information refer -> https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-relate-unrelate
Hi @jawalley
your syntax should be like this..
In this case relationship is from Account -> TempEntity (one to Many), meaning one account can have multiple child temp entity records
Relate(Dropdown1.Selected.TempEntities,Dropdown2.Selected)
(dropdown 1 is list account and dropdown 2 is list of temp entity records)..
for more information refer -> https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/functions/function-relate-unrelate
@MayankP
Okay, so it looks like my formula was backwards. The "One" should be the first argument and the "Many" the second. Making that adjustment I got the Relate function to work. However because that doesn't specify the lookup column in the "Many" table, I have another issue.
I have two relationships between "People" and "Meetings". A 1:N relationship called "Primary" and a N:N relationship. How can I use the Relate function to relate a "Person" to the "Primary" field in a "Meeting"?
The Relate function works if I only have the 1:N relationship, but does not work when I also have a N:N relationship between the two tables.
I am currently getting the error "The function 'Relate' has some invalid arguments.
I have reposted my more specific question here https://powerusers.microsoft.com/t5/Microsoft-Dataverse/Relate-function-multiple-relationships-betwe...
since @MayankP did answer my original question
User | Count |
---|---|
20 | |
13 | |
8 | |
5 | |
5 |
User | Count |
---|---|
33 | |
30 | |
14 | |
13 | |
9 |