How to find find matching rows from a table

Anonymous · ‎04-25-2019

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:

Column	Values
Alert Category	Message Alert
Service Category	test Category
Region	test Region
State	test State

Can anyone suggest how to achieve this?

v-frfei-msft · ‎04-25-2019

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.

Community Support Team _ Frank
If this post helps, then please consider Accept it as the solution to help the others find it more quickly.

Anonymous · ‎04-26-2019

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