Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

How to find find matching rows from a table

Hi,

I have a table like below:

Now I want that when I select one value from 'Record Key' column , it will show the related values like below table:

ColumnValues
Alert CategoryMessage Alert
Service Categorytest Category
Regiontest Region
Statetest State

Can anyone suggest how to achieve this?

 

Need Help

2 Replies

  • v-frfei-msft's avatar
    v-frfei-msft
    Icon for Community Support rankCommunity Support
    7 years ago

    Hi Anonymous ,

     

    Could you please share your sample data to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      Hi,

      I have created a demo app and attaching the link. I want that when I select the customer ID from table1, it will show realted data in below 2nd pivot table. For this I have created a Pivot table with column name and Values. But it does not work.

       

      So please help me how to achive this functionality?

      https://drive.google.com/open?id=1Qk8mfDfUBINNUC2S0FHbgGb8JJmInFv5