SOLVED

Create a SPO list with subitems

%3CLINGO-SUB%20id%3D%22lingo-sub-2706139%22%20slang%3D%22en-US%22%3ECreate%20a%20SPO%20list%20with%20subitems%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2706139%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20this%20idea%20where%20i%20want%20to%20have%20a%20SPO%20list%20with%20all%20our%20meeting%20rooms%2C%20and%20everything%20a%20room%20is%20booked%20the%20new%20reservation%20to%20go%20under%20the%20room%20that%20is%20about.%3C%2FP%3E%3CP%3EThe%20list%20structure%20is%20this%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Radoslavov91_0-1630484917102.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F307237i2ABFB56446CD0BAB%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Radoslavov91_0-1630484917102.png%22%20alt%3D%22Radoslavov91_0-1630484917102.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3ESo%20for%20example%20i%20want%26nbsp%3B%20to%20be%20able%20to%20see%20all%20bookings%20for%20Red%20room%20kind%20of%20like%20a%20tree%20structure%20with%20option%20to%20expand%2Fcollapse%20the%20main%20item%20row%2C%20because%20if%20there%20are%2020%20rooms%20and%20the%20list%20cannot%20be%20collapsed%20this%20might%20be%20quite%20hard%20to%20read%20as%20everything%20will%20be%20expended.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERed%20Room%3C%2FP%3E%3CP%3E%26nbsp%3B%20-%20Booking%201%3C%2FP%3E%3CP%3E%26nbsp%3B%20-%20Booking%202%3C%2FP%3E%3CP%3E%26nbsp%3B%20-%20Booking%203%3C%2FP%3E%3CP%3EGreen%20Room%3C%2FP%3E%3CP%3E%26nbsp%3B%20-%20Booking%201%3C%2FP%3E%3CP%3E%26nbsp%3B%20-%20Booking%202%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eand%20so%20on....%20you%20got%20the%20idea.%20Any%20suggestions%20how%20this%20can%20be%20achieved%20and%20references%20or%20help%20to%20achieve%20it%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERegards%3C%2FP%3E%3CP%3EKiril%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2706139%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ELists%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2706305%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20SPO%20list%20with%20subitems%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2706305%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F345126%22%20target%3D%22_blank%22%3E%40Radoslavov91%3C%2FA%3E%26nbsp%3Bcreate%20a%20new%20view%20of%20the%20list%2C%20edit%20the%20view%20and%20select%20which%20column%20you%20want%20to%20view%20by%20and%20whether%20you%20want%20it%20to%20default%20to%20collapsed%20or%20expanded%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22groupBy0.png%22%20style%3D%22width%3A%20474px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F307243iA9F8D8DC3B8CBCA3%2Fimage-dimensions%2F474x363%3Fv%3Dv2%22%20width%3D%22474%22%20height%3D%22363%22%20role%3D%22button%22%20title%3D%22groupBy0.png%22%20alt%3D%22groupBy0.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThen%20you'll%20click%20on%20the%20dropdown%20to%20display%20the%20bookings%20for%20that%20room%20(or%20in%20my%20live%20example%2C%20location).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-center%22%20image-alt%3D%22groupBy.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F307244i0C507ED8E5B80527%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22groupBy.png%22%20alt%3D%22groupBy.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23006400%22%3EIntranet%2C%20SharePoint%20and%20Power%20Platform%20Manager%20(and%20classic%201967%20Morris%20Traveller%20driver)%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2706336%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20SPO%20list%20with%20subitems%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2706336%22%20slang%3D%22en-US%22%3EGreat%20Rob%2C%3CBR%20%2F%3E%3CBR%20%2F%3Ethis%20was%20exactly%20what%20i%20was%20looking%20for%2C%20thanks%20for%20the%20quick%20help%20%3A)%3C%2Fimg%3E%3CBR%20%2F%3E%3CBR%20%2F%3ERegards%3CBR%20%2F%3EKiril%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi all, 

 

I have this idea where i want to have a SPO list with all our meeting rooms, and everything a room is booked the new reservation to go under the room that is about.

The list structure is this:

Radoslavov91_0-1630484917102.png

So for example i want  to be able to see all bookings for Red room kind of like a tree structure with option to expand/collapse the main item row, because if there are 20 rooms and the list cannot be collapsed this might be quite hard to read as everything will be expended.

 

Red Room

  - Booking 1

  - Booking 2

  - Booking 3

Green Room

  - Booking 1

  - Booking 2

 

and so on.... you got the idea. Any suggestions how this can be achieved and references or help to achieve it?

 

Regards

Kiril

2 Replies
best response confirmed by Radoslavov91 (Occasional Contributor)
Solution

@Radoslavov91 create a new view of the list, edit the view and select which column you want to view by and whether you want it to default to collapsed or expanded:

groupBy0.png

 

Then you'll click on the dropdown to display the bookings for that room (or in my live example, location).

 

groupBy.png

 

Rob
Los Gallardos
Intranet, SharePoint and Power Platform Manager (and classic 1967 Morris Traveller driver)

Great Rob,

this was exactly what i was looking for, thanks for the quick help :)

Regards
Kiril