Showing results for 
Search instead for 
Did you mean: 
Not applicable

Showing Records from different entities

Hi People,
I have a requirement in my app that in a single tab we need a table of all records from different entities.
Is it possible?

Resolver IV
Resolver IV

Hi @Anonymous !


Can you be a little more specific. What are you trying to accomplish? How are the entities related to each other? 



Not applicable

@pontusofswedenWe have 3 entities in which I have different records and those 3 are not related to each other but at a single screen I need to show the list of all records and along with those records an added column in which it will display the entity name.

Ok! Do you have the same column names (ish) in all the entities? One approach is to create a collection where you merge all the records from each entity and add a column for the Entity name. Then you can use the new collection as a single datasource in a gallery. Here is a sample formula to merge the records:




If you have different column names, you can add conditions for the labels in the gallery. Like:












Not applicable

@pontusofswedenThanks for your reply!
No, I don't have any columns with same name in all 3 entities And also what are you referring to when you said "Table A".?
I just need a list of records.



TableA is in your case EntityA (since I dont know the name of your entities). The problem is that you can only use one datasource in a gallery, for instance. My suggestion, according to the formula provided, is to merge EntityA, EntityB and EntityC into a new Collection (NewTable) that you can use as a datasource in the gallery. With this formula, all records in the list will have a reference to the Entity which you can show on the screen.




Not applicable

@pontusofswedenWe did manage to create a collection the trouble that we are having is that we are not able to add a column that specifies the name of the entity that record is from.
Can you help me with that?

Happy Holidays

Hi @Anonymous ,

Do you mean that you have 3 entities that have no relationship, you want to save them to the same collection and add a column record its entity names?

If so,I've made a similar test for your reference:

Since these three entities have different column names, I'm afraid you need to firstly create a table will all fields'name that these three entities have. Or else, you can not save them together.

Try this formula:


Please note that you need to pay attention to the data type in step1. "" represent text type. If the field is not text type, then you could not update successfully in step2.

If it is a choice type, you need to use fieldname:{Value:""}  at step1.

If it is datetime type, you need to use DateTimeValue("") at step1.


Best regards,

Community Support Team _ Phoebe Liu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Not applicable

@v-yutliu-msftThank you so much.
Should I write this code on OnVisible Property of the page where I want to show the data ?
Sorry im a beginner in powerapps.



Yeah, you need to trigger the merge somehow. Maybe on OnSelect of the button that gets you to your screen? OnVisible is also an option of course, I rarely use it myself but it´s doable.




Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

May UG Leader Call Carousel 768x460.png

June User Group Leader Call

Join us on June 28 for our monthly User Group leader call!

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.


New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Users online (1,230)