Expand N:N intersect table with Dataverse Web API

(0) Share

Report

Posted on by AnthonyD

559

Hi All,

Lets say i have 2 tables

Employee
Training

These are in a N:N. When i query the Intersect table with EmployeeID = ID, it returns me all intersect records from that employee. Is it possible somehow to expand this query to hold all data about lets say the trainings it returned?

Best Regards,

Anthony

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Community Power Pla... on at

Like (1)

Report

Are you using a FetchXML query to do that? If so, I think you may need an (inner) join between your intersect table and your Training table to achieve what you're asking.

If you're using OData, I think you may need to use $expand (https://learn.microsoft.com/en-us/power-apps/developer/data-platform/webapi/retrieve-related-entities-query)

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@Anthony_Dob If my previous post solved your question, please consider clicking on "Accept as solution" to help the other members find it more quickly. Thanks! 🙂

Was this reply helpful? Yes No
AnthonyD 559 on at

Like (1)

Report

I am Using OData queries. I don't think i can use a $expand on a Intersect table as i tried it. That is why i am asking here if there may be another way to get the related data in 1 query

Was this reply helpful? Yes No
Verified answer

Guido Preite 1,488 Super User 2024 Season 1 on at

Like (0)

Report

with the OData Web API you don't need to start with the intersect table. Start with the employee table (so you put the filter there for employee id) and you expand the N:N relationship in order to get the training columns.

Was this reply helpful? Yes No