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!
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
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?
Keep up to date with current events and community announcements in the Power Apps community.
A great place where you can stay up to date with community calls and interact with the speakers.
Check out the latest Community Blog from the community!