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.


Report
All responses (
Answers (