Grouping in a table

[rbjames]

Hi,

I've created a timetabling power app for music lessons. Data is stored in sharepoint lists and I have several joined in the model to produce the visual below. 

Each teacher has an ID in a lessons table which gets the teachers name from a teachers table. For this single table I'm just filtering by id (1 in this teacher's case). We have 11 teachers and I'd like to be able to show all of their lessons in a grouped table to look similar to this:

...but only display the table if the teacher has lessons that day. How can I best achieve this? I know I can just create 11 separate tables within the visual but I'll be displaying a lot of blank tables for teachers who aren't in on that particular day which isn't ideal.

Any advice very gratefully received.

Richard

[rbjames]

Thank you for your idea. This is going to be on a signage screen so there will be no option for interactivity. The table you have entered is for just one teacher so there will be another 10 tables similar to that one. 

[Anonymous · Accepted solution]

Hi @rbjames ,

I think you can use drill through. Maybe this can help you. Firstly you can create a new Page, then you can use put name in drill through selection.

You can create more Pages.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hi @rbjames ,

I create a table as you mentioned.

Then I use a slicer by Name.

I think you can use Bookmarks, it will give you static status display.

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.