Forum Discussion
Create Multiple Cards from a Primary Key between two tables
Hi Anonymous ,
I think there may not be a good way to solve your problem directly, I will provide an indirect method, but I am not sure if it can meet your needs:
1. You can create a many-to-many relationship between the two tables, Roles and Employee:
2. Use the Group Name field as a slicer ，then create the Multi-row card (next to the Card) of the Employee field and the Roles field. After aligning the border, select Group. The results are as follows:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-joesh-msft ,
Thank you for taking time to read, that was a mistake on the tables. I apologize. I have gone ahead and updated the tables. Let me know if that makes sense? Basically, we do not want to merge the tables but we want to create a report with multiple Card-like structures where the title of the card is the group name and it has two columns underneath (The roles and the employees that are associated with that specific group name). Something like a group-by.
I will however, go through the links as they might help get closer to what we want to achieve, thank you.
Hi Anonymous ,
I think there may not be a good way to solve your problem directly, I will provide an indirect method, but I am not sure if it can meet your needs:
1. You can create a many-to-many relationship between the two tables, Roles and Employee:
2. Use the Group Name field as a slicer ，then create the Multi-row card (next to the Card) of the Employee field and the Roles field. After aligning the border, select Group. The results are as follows:
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you so much!! You are a genius, this helps us get near to what we need!