Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Model Driven PowerApp how to write or execute query among entities?

Hi All, I have one question about the model-driven power app. I know before loading a data source as an entity, there is a tool called power query which can support joint queries among tables. But I don't know if there is a way to write or execute queries among entities, which means after I loaded several entities, I would like to write or execute queries among those entities. I've tried the relationship properties and play around the one-to-many, many-to-one relation, but what I've done is displaying a lookup view or related data grid instead of writing queries. I have seen several demos based on the canvas-driven app that it supports you writing a query inside a text input and based on the flow you set, it can retrieve data from data sources. My question is how to achieve it in a model-driven power app?

Helpful resources

Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Power Platform ISV Studio

Power Platform ISV Studio

ISV Studio is designed to become the go-to Power Platform destination for ISV’s to monitor & manage published applications.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (10,670)