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

I have the same question (0)

All responses (6)

Answers (0)

CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

@JT_Corrin try putting SelectedTask as the first parameter.

Was this reply helpful? Yes No
JT_Corrin 104 on at

Like (0)

Report

Thanks @CNT - the first parameter expects a table and the second a record - so SelectedTask as first parameter throws an error

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

@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 ) )

Was this reply helpful? Yes No
JT_Corrin 104 on at

Like (0)

Report

But you have passed a table first and a record second in both of those examples...

Was this reply helpful? Yes No
CNT 10,921 Super User 2024 Season 1 on at

Like (0)

Report

@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.

Was this reply helpful? Yes No
JT_Corrin 104 on at

Like (0)

Report

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

Was this reply helpful? Yes No