Answered

How to add a relationship table to a canvas app?

(0) Share

Report

Posted on by Cooper01

664

I created a N:N relationship between two tables. My understanding is that Dataverse creates a third table to store the related items.

My tables are called Books and Authors. I have a dropdown list with all Books and when a user selects one, I want to display related author(s) in a gallery below.

How do I access this table in a canvas app? Do I need to explicitly bring it in with Add Data in the Data pane? I can see the Relationship table name in the relationship settings on my table. I'm trying to plug that value into the items property of a gallery just to see what I'm working with but I can't get anything to resolve.

Does anyone have an example they could point me to on what this filter would look like? Thanks in advance.

Categories:

Building Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Sort by

zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I am using two different SharePoint list which are linked with each other through parent id.
1. Candidate
2.Submission

1 Candidate can have many submission.
I added both the list in powerapps. And here's how it works:

Was this reply helpful? Yes No
Cooper01 664 on at

Like (0)

Report
Copy link

Link copied!

Thanks for the reply @zmansuri but I am specifically looking to access N:N relationships in Dataverse which don't seem to work quite the same way as lookup columns in either Dataverse or SharePoint.

Was this reply helpful? Yes No
zmansuri 6,048 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

I am not using lookup columns.
Sorry i couldn't be more helpful

Was this reply helpful? Yes No
Verified answer

Cooper01 664 on at

Like (0)

Report
Copy link

Link copied!
This was not as complex as I was making it. I was able to get this working by created a collection in the OnChange of the drodown list. Still not sure about accessing the relationship table but you can get at the related items using dot notation, similarly to how you would reference a column. OnChange property
ClearCollect(colRelatedRows, ddlBooks.Selected.Authors)
I found this blog post helpful: https://powerapps.microsoft.com/en-us/blog/option-sets-and-many-to-many-relationships-for-canvas-apps/

Was this reply helpful? Yes No