
Announcements
How to display Subgrid Values from another table in Parent Table Main form so that we can use it to compare with other table to get common filter data value.
We have a customer details table - having a subgrid from table Subjects example: ENG; TAM
We have a subject table: contains the subjects with column name called Subcode : ENG ,TAM, LIN, etc
We have a title table cotnains all the tiles with Subject data as subgrid.
We need to compare Customer table datagrid value with Title table data grid value and get the common values as like below
Customer name | Title Name.
Help how to achieve this.
I am using power automate to send emails to the common values witht the relevant title.
Hi @bsabapathy ,
Is your data model something like the following in this situation?
Where you have an N:N between Subject and Customer Detail and you have a 1:N from Subject to Title? Are you just focused right now on the Power Automate process to be able to send the email with the Customer and all of their titles (could be multiple)? Another option is your Subject to Title relationship is N:N as well? Please respond how this is setup to better assist.