Unanswered

Two Table Dataverse View

(0) Share

Report

Posted on by KS-04101812-0 Microsoft Employee

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?

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@kaswiere

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.

Was this reply helpful? Yes No
KS-04101812-0 Microsoft Employee on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Mira Ghaly 11,413 Moderator on at

Like (0)

Report

@kaswiere

If you can please share some screens so we can understand the issue more.

Was this reply helpful? Yes No