Announcements
Hi All,
Lets say i have 2 tables
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
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)
@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! 🙂
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
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.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
Congratulations to our 2026 Super Users!
Congratulations to our 2025 community superstars!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
wolenberg_ 119 Super User 2026 Season 1
WarrenBelz 107 Most Valuable Professional
Haque 103