You’re offline. This is a read only version of the page.
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
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.
@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! 🙂
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)
#1
WarrenBelz
637
Most Valuable Professional
#2
stampcoin
570
Super User 2025 Season 2
#3
Power Apps 1919
473
Share
Report
All responses (
Answers (
