cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Caddy2
Regular Visitor

Lookup any value from related table

Hello,

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!

 

Greetings

 

4 REPLIES 4
rampprakash
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 : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA

Blog : https://microsoftcrmtechie.blogspot.com

Caddy2
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.

dpoggemann
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.
Thanks,
Drew

Helpful resources

Announcements
Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Users online (4,838)