Brisbane Power Apps and Power Automate User Group

Please login or click SIGN UP FOR FREE to create your PowerPlatformUG account to join this user group.
Expand all | Collapse all

Help please with powerapps filter

  • 1.  Help please with powerapps filter

    Posted Jun 20, 2020 04:44 AM

    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.

    RubesandBoogs_0-1592556371938.png



    ------------------------------
    Rae Cole
    ------------------------------


  • 2.  RE: Help please with powerapps filter

    Top Contributor
    Posted Jun 21, 2020 06:31 PM
    Edited by Warren Belz Jun 21, 2020 06:32 PM
    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
    ------------------------------