cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
FredericForest
Kudo Kingpin
Kudo Kingpin

Relate Syntax

Hi guys,

I'm trying to wrap my head around using the Relate() function in a one to many relationship and I'm just not managing it. I've exhausted just about every combination I can think about, and still no luck. 
For what I'm getting, I should be doing something like : 

Relate(
   TableManyRecord.LookupColumn
   ,TableOneRecord
)

As an exemple, I have a Product table with a lookup field called LOOK_Category to a categories table. I'm trying the most basic version (and about every other combination I can think about) and still no luck.
Relate(
    First(Product).LOOK_Category
    ,First(Category)
)

I'm on Dataverse For Teams by the way. Anyone knows where I'm going wrong?

1 ACCEPTED SOLUTION

Accepted Solutions
HFG
Helper IV
Helper IV

Hi @FredericForest , 

 

I believe you need to add the name of the other table in your code. Something like: Relate(First(Category).Product, 
    First(Product)
)

 

Hope that helps! 🙂

 

 

View solution in original post

1 REPLY 1
HFG
Helper IV
Helper IV

Hi @FredericForest , 

 

I believe you need to add the name of the other table in your code. Something like: Relate(First(Category).Product, 
    First(Product)
)

 

Hope that helps! 🙂

 

 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,381)