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

User Groups Public Preview

Join us for our User Group Public Preview!

Power Apps User Groups are coming! Make sure you’re among the first to know when user groups go live for public preview.

Power Apps Community Call

Monthly Power Apps Community Call

Did you miss the call?? Check out the Power Apps Community Call here!

Power Platform ISV STudio

Power Platform ISV Studio

ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.

Top Solution Authors
Top Kudoed Authors
Users online (32,766)