Help with settings controls and showing a gallery subgroup

%3CLINGO-SUB%20id%3D%22lingo-sub-1481707%22%20slang%3D%22en-US%22%3EHelp%20with%20settings%20controls%20and%20showing%20a%20gallery%20subgroup%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1481707%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20having%20some%20trouble%20accomplishing%202%20tasks.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CU%3EFor%20reference%3A%26nbsp%3B%3C%2FU%3E%3C%2FP%3E%3CP%3EDatasource%20is%20excel%20file%20(Table1)%3C%2FP%3E%3CP%3EgallAll.Items%20%3D%20GroupBy(Table1%2C%20%22Hospital%22%2C%20%22grpByHosp%22)%3C%2FP%3E%3CP%3EgallHosp.Items%20%3D%26nbsp%3BSort(Filter(Table1%2C%20And(ThisItem.Hospital%20%3D%20Hospital))%2C%20Room%2C%20Descending)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1.%20How%20to%20make%20toggHosp%20toggle%20show%2Fhide%20corresponding%20subgroup.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E2.%20How%20to%20selectively%20set%20toggHosp%20toggle%20via%20the%20buttons%20(ALL%2CSR%2CN%2CS).%20For%20Example%2C%20N%20button%20selects%20MRMC%20and%20unselects%20all%20others.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202020-06-22%20at%202.06.32%20PM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200122iCC43B764DE122065%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screen%20Shot%202020-06-22%20at%202.06.32%20PM.png%22%20alt%3D%22Screen%20Shot%202020-06-22%20at%202.06.32%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screen%20Shot%202020-06-22%20at%202.07.01%20PM.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F200123iA57C72FA9F0C8E22%2Fimage-size%2Fmedium%3Fv%3D1.0%26amp%3Bpx%3D400%22%20title%3D%22Screen%20Shot%202020-06-22%20at%202.07.01%20PM.png%22%20alt%3D%22Screen%20Shot%202020-06-22%20at%202.07.01%20PM.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3CP%3E%E2%80%83%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1481707%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EPowerApps%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

I am having some trouble accomplishing 2 tasks.

 

For reference: 

Datasource is excel file (Table1)

gallAll.Items = GroupBy(Table1, "Hospital", "grpByHosp")

gallHosp.Items = Sort(Filter(Table1, And(ThisItem.Hospital = Hospital)), Room, Descending)

 

1. How to make toggHosp toggle show/hide corresponding subgroup.

 

2. How to selectively set toggHosp toggle via the buttons (ALL,SR,N,S). For Example, N button selects MRMC and unselects all others.

 

Screen Shot 2020-06-22 at 2.06.32 PM.png

Screen Shot 2020-06-22 at 2.07.01 PM.png

1 Reply

Answered my own 1st question. Just set gallHosp.Visible = toggHosp.Value. Still looking for help with #2.