I have three tables. Table 1, Table 2 and Table 3.
Table 1 is related to Table 2.
Table 2 is related to Table 3.
I am planning to create a grid which displays a count of responses based on the category and their possible responses (Table 3)
Currently, I am able to get the count responses by grouping the responses from Table 1 but I am unable to get the category values from Table 3.
I am able to achieve the Overview column which gives me the unique count based on the responses but I am unable to relate it to the "Category" column. What is the best way to relate Table 3 with Table 1?
I have tried various functions such With, ForAll and other references including but no luck.
Here is an example of the grid that I am trying to achieve.
I have created a collection for table 1 which I have filtered based on my requirement that gives me responses, question name and lookup table to table 2. I am trying to add a column which gives me data from the Table 3.
'Tabl1'.ID = GUID(ID)
), "CategoryValue", LookUp('Table3', Category = lookup_Table2.Category.CategoryId).Category)
This formula gives me blank values on the "CategoryValue" column in my collection.
@SD_PowerUser Category = lookup_Table2.Category.CategoryId will not work. You can't go more than one level deep. So, first you have to do a LookUp to get the related record from Table2 and then do another LookUp to get the related record from Table3.
Ok, thanks for this @CNT.
So you are saying to do something like this?
Filter( 'Table1', 'Tabl1'.ID = GUID(ID)),
"CategoryValue", LookUp('Table3', Table3Id
= Lookup(Table2, Table2Id
Closing this ticket as there was no straight forward solution. Had to do a work around in order to reach our objective. Thanks for your help. @CNT
Join us for the next call on August 17, 2022 at 8am PDT.
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.