
Hi,
I'm working with Power Pages page. Since we have several tables (4 tables) as below.
These 4 tables has same column named "Name" and "Age".
I would like to show all records gathered from 4 tables to one "Lists". Seems like one list can attach one table but is there any way to show gathered data from different table to one?
Hi @Sam44,
I don't think that there's a solution out of the box for your problem.
What you can do is use liquid and fetch XML. But that depends if your list can be preloaded into the page with conditions which are not changed afterwards. https://learn.microsoft.com/en-us/power-apps/developer/data-platform/use-fetchxml-construct-query
The only other solution would be to use the CRUD Api and gather the information over a button than use JS and HTML to display a table inside your page. https://www.youtube.com/watch?v=5PwLZd_HE30
Another feature which could help are the cloud flows which are currently in preview but can respond to a call with all the data you need. https://learn.microsoft.com/en-us/power-pages/configure/cloud-flow-integration
--------------------------------------------------------------------------------------
Hope that helps.
If the post solves your problem, please mark it as solution. If it helps, consider a thumbs up.