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!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.


Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (15,149)