cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kriseuro
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.

2 REPLIES 2
jlindstrom
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 https://powerusers.microsoft.com/t5/Building-Power-Apps/Creating-collection-from-multiple-tables/td-...

 

@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

Announcements
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

Power Apps Community Call

Monthly Power Apps Community Call

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

secondImage

Experience what’s next for Power Apps

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

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.

Users online (54,962)