Hi Rae,
I am assuming your labels on the first gallery are based on the
'Function Name' field in
'Risk Incident Management Form'. Also note my field names below may be not exactly yours. The first Vertical gallery would have the
Items
Filter(
'Risk Incident Management Form',
'Function Name' = FilterGallery.Selected.'Function Name'
)
and display the field 'Incident Owner'
The second vertical gallery will have the Items
Filter(
'Risk Incident Management Form',
'Incident Owner' = 'Incident Owner Gallery'.Selected.'Incident Owner'
)
and display the field 'Incident Status'
The Item of your Form would be
'Incident Status Gallery'.Selected
------------------------------
Warren Belz
Queensland Australia
------------------------------
Original Message:
Sent: Jun 20, 2020 04:43 AM
From: Rae Cole
Subject: Help please with powerapps filter
Hoping someone can help me on my PowerApp Filter
I have a Blank Horizontal Gallery called FilterGallery that has Labels
I have another Vertical Gallery called IncidentOwnerGallery with the layout, Title.
Title36: Incident Owner
My final Vertical Gallery called IncidentStatusGallery
My data Source is Risk Incident Management Form
What I am trying to do is in the labels of the FilterGallery, have the Function Names, column name (Function Name) in my sharepoint list, so when you click on any function, it filters the Incident Owner Gallery first, then the Incident Status Gallery of which can then navigate to a new screen that shows the entire record which can be viewed or edited.
If anyone can help me figure this out, I would be so grateful.
------------------------------
Rae Cole
------------------------------