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

Fetch the data from more than two entities in canas apps

Created one canvas application having the datatable to display the data. To display the data in datatable, need to fetch the data from more than two entities. 

can you please help on this.

Super User
Super User

tell us more about these entities. Are they related to each other? If so how? do they all describe the same record, or do they refer to child or hierarchically related data?


You should add the other entity connections to your app, then you can display any of the data you want in your app. how you display that data will depend on how it is related to each other.


For example, say your app needs Accounts, related contacts, and related car records. You could have a data table or gallery of accounts, then have the selected record navigate to a screen where you show galleries or data tables of cars and contacts related to the selected account.


Or if your data is normalized and has a common identifier between the different entity records all describing the same records (email addresses in one entity, phone number in another entity, etc), you could build a collection that combines all of the data into one collection and then display the collection in your data table. See @mdevaney  answer in this post


@kriseuro  if this answers your question, please mark it a solution

Entities are related to each other.  

First Entity have relationship with seconds entity. Second entity have relationship with third entity. In Datatable/gallery need to display the data with joining these three entities. From two entities able to fetch the selected columns and display in datatable /gallery. But need help to fetch the required columns from three entities. 


Could you please provide suggestions.

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

PA Community Call

Power Apps Community Call

Next call is happening on April 21st at 8a PST.

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!


Experience what’s next for Power Apps

See the latest Power Apps innovations, updates, and demos from the Microsoft Business Applications Launch Event.

Users online (75,808)