Relate function not working on many to many

(0) Share

Report

Posted on by JT_Corrin

104

Hi everyone,

I have a table called "Tasks". It has two many-to-many self-referential relationships:

"Dependent"

"Contingent"

Why does only one the first of these relate functions work?:

ForAll(
 colNewTasks, // Picked from a gallery of 'Tasks'
 Relate(SelectedTask.'Dependent', ThisRecord); // SelectedTask is a record selected from a gallery of 'Tasks' - this works.
 Relate(ThisRecord.'Contingent', SelectedTask) // This does not work
)

Thanks for any assistance

Categories:

Building Power Apps

All responses (6)

Answers (0)

Sort by

CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@JT_Corrin try putting SelectedTask as the first parameter.
JT_Corrin 104 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks @CNT - the first parameter expects a table and the second a record - so SelectedTask as first parameter throws an error
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@JT_Corrin that's not quite true. You relate two records as shown in the following example in the Power Apps documentation,

Products and Contacts are related through a Many-to-Many relationship. To relate the first record of the Contacts table with the first record of the Products table:

Relate( First( Products ).Contacts, First( Contacts ) )

As Many-to-Many relationships are symmetric, we could also have done this in the opposite direction:

Relate( First( Contacts ).Products, First( Products ) )
JT_Corrin 104 on at

Like
a
(0)

Report
Copy link

Link copied!

But you have passed a table first and a record second in both of those examples...
CNT 10,921 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@JT_Corrin First( Products ).Contacts and First( Contacts ).Products return just one record and not a table. Further please remember, all relationships are between records. On record in a table relates to another record in another (or same) table.
JT_Corrin 104 on at

Like
a
(0)

Report
Copy link

Link copied!

They return the first Products table of contacts and the first Contacts table of products

I get what you are saying though. Thanks for the assistance