Showing results for 
Search instead for 
Did you mean: 
Regular Visitor

Lookup any value from related table


I need several dataverse tables, where one table should look up values from another tables. There is an m:n connection between the tables.

Is there a way to do this without code?
If I understand it correctly lookup columns show only the primary column of the other table and business rules are not possible and there is no parent-child relationship where calculated fields could be used right?

Would be great if someone could help me with this!




Super User
Super User

Hi @Caddy2 


Am afraid it is not possible,


Consider if we have Account and Opportunity Table


Opportunity contains Account Lookup which is From account it is 1:N Relationship but we cannot use the Opportunity lookup, if we are using Lookup it will be 1:N from account level,


But you can use Subgrid to show the values


Please mark as Answer if it is helpful and provide Kudos

Subscribe :

Blog :

Regular Visitor

Thanks for your quick answer @rampprakash!

So to get the values in the process of creating a new entry, I have to use a plug-in right?

Yes thats the best way i can say else use Microsoft flow.

Super User
Super User

Hi @Caddy2 ,


Usually to accomplish what you are trying to do here I utilize custom "Intersect" or "Join" tables where I have the following type of model:

               1      N                       N       1

Table A  ------->  Intersect C  <------  Table B


This allows me to then have two lookups on the Intersect table with Table A and Table B.  You can utilize real-time workflows to set values on this intersect table from the related lookup tables (A & B).  Note, Business Rules apply to same table, not related tables.


Is this what you are looking to do?


Hope this helps. Please accept if answers your question or Like if helps in any way.

Helpful resources

Users online (4,243)