I am having trouble setting up a view between two tables. For example, I have a customer table and an order table. I want to create a view in the order table that shows information about the customer. The customer table also has a lookup column to the user table which has the customer name information. In the view, I setup a customer column from the related customer table and can see the customer id but I can't see any user information from the user lookup column.
How do you setup a view that joins two tables so I can see all the data from each table including lookup columns?
I am just trying to setup the view so I can use it in Power Apps. When I view the data from the view in Dataverse it is not showing the data for the user lookup column in the customer table.
I am not quite sure if I got your question right if you are using model driven app, when you click Add View column, Select related and then the table customers at your end and then you can any of the columns on your customer table.
stampcoin
17
ankit_singhal
11
Super User 2025 Season 1
mmbr1606
9
Super User 2025 Season 1