Create a view using several tables

(0) Share

Report

Posted on by EmilioRoqueta69

565

Hi,

I have, for example, 3 dataverse tables:

Hardware

User | Date | Subject | other columns

Software

User | Date | Subject | other columns

Telephony

User | Date | Subject | other columns

Can I create a view that shows the records of the 3 tables containing the common columns?

User | Date | Subject

Thanks in advance for any help!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (5)

Answers (0)

Sort by

Linn Zaw Win 2,996 on at

Like
a
(2)

Report
Copy link

Link copied!

@EmilioRoqueta69

It is not possible to combine x3 tables and show the rows from different tables in a single view in a model-driven app.

However, you can add a custom page to your model-driven app and collect the records of the 3 tables into a single collection and show it in a data table control.

Was this reply helpful? Yes No
Fubar 8,505 Super User 2026 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
Create a View is not possible.

But, you could potentially do something in a
Canvas app (could be standalone or embedded on a model driven app form), https://powerusers.microsoft.com/t5/Building-Power-Apps/Gallery-with-multiple-tables/td-p/1021607 or
write a PCF component to do it.

Was this reply helpful? Yes No
powerx365 42 on at

Like
a
(1)

Report
Copy link

Link copied!

Not out of the box like others have mentioned. You could, however, do so using Power BI relatively easily (comparing it to a custom PCF control). You can then embed that app in a form as well and dynamically filter it (if this needs to be a sub-grid). Or simply add it to the Sitemap or Dashboard's list.

Cheers,

Rajat Joshi
Power x 365
Experience the Difference

Was this reply helpful? Yes No
EmilioRoqueta69 565 on at

Like
a
(0)

Report
Copy link

Link copied!

Ok, it is a canvas app.
Thank you all

Was this reply helpful? Yes No
GabrielRoch 4 on at

Like
a
(1)

Report
Copy link

Link copied!

Hi Rajat, I would like to create a feature like the one your a describing in this post, would you be able to elaborate on how to do so? we can also get in touch. Thanks in advance!

Was this reply helpful? Yes No