Unanswered

Lookup Column other than Primary column in Dataverse

(0) Share

Report

Posted on by Kavya1

I have a scenario where I want to have a lookup column to be created in Dataverse Table 2 looking up to Table 1 other than a primary column. Is this possible? If so, I want each and every possibilities to analyze.

Example:

Dataversetable1 - EmpName(PK), EmpCode, PhoneNumber, Address

Dataversetable2- ProjectName(PK), EmpName(Lookup), EmpCode(LookUp), ProjectCode

From above example I need the ways how I can create lookup EmpCode in second table.

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (0)

365-Assist 2,324 Moderator on at

Like (0)

Report

What functionality are you trying to achieve?

If you are trying to do this in a Model Driven App then I can't see how. As Dataverse relationships need the ID column to be used for the lookup column.

You could however create a Custom Page or Canvas App and use Galleries or Collections to do the lookup.

If you are just using it reports then you could create a Power Query in Power BI or Excel.

---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.

Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365

Regards
Darren Lutchner - 365 Assist

Was this reply helpful? Yes No
Kavya1 54 on at

Like (0)

Report

I am trying to achieve this in Model Driven app.

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

Like (0)

Report

@Kavya1

Is code a separate table? or it is just a text field on the employee table?

If it is a field you do not need another lookup , if you wanna to display the employee code on the project form you can use a quick view to achieve this.

https://learn.microsoft.com/en-us/power-apps/maker/model-driven-apps/create-edit-quick-view-forms

Was this reply helpful? Yes No
Kavya1 54 on at

Like (0)

Report

Thanks @Mira_Ghaly . Will try it out.

Was this reply helpful? Yes No