Two different lookup columns from same table

(0) Share

Report

Posted on by CCAutomations

I have two tables: my main table called Projects, and another Contacts table (OOB table).

Within my Contacts table, I have two types: Customer and Contractor, which are differentiated by a category column.

In my Projects table, I would like a lookup column for Customer and a second lookup column for Contractor. Each one looks up to the same table (the Contacts table).

Is this possible? For reference, I am using these tables in a model-driven app.

TIA!

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

Drew Poggemann 9,287 Most Valuable Professional on at

Like (0)

Report

Hi @CCAutomations

That is not a problem. You can have multiple lookups to the same table on another table. Let me know if you run into any issues but I do this all the time.

Was this reply helpful? Yes No
CCAutomations 13 on at

Like (0)

Report

Attached is a visual of what I am trying to achieve. (Sorry, I used the word Vendor instead of Contractor here).

TableExample.png

Was this reply helpful? Yes No
Fubar 8,340 Super User 2025 Season 2 on at

Like (0)

Report

As per Drew's post for a given Table you can have multiple Lookup columns to the same Table.

When you create the second one, if you type the same Display name as the first one you may need to change the default schema name (as otherwise it will default to the one already created and error) - but this wouldn't be an issue if the columns have different names.

One thing that has been an issue in the past in a model driven app is if creating the record with the 2 lookups of a parent record and there is relationship mapping it would fill in both Lookups with the same value (the workaround for this was to put in some JavaScript to clear one of the fields).

Was this reply helpful? Yes No
CCAutomations 13 on at

Like (0)

Report

Thank you both! I was able to create my second column with the same lookup to Contacts in my main Projects table.

In my MDA, I'm having issues seeing the filtered views for each field. I can select the Customer View for the Customers field, but don't see an option for my Vendor View I created, in my Vendor field in the MDA.

Vendor.png

Customer.png

Was this reply helpful? Yes No