Skip to main content

Notifications

Power Apps - Building Power Apps
Answered

Using multiple filters to control a Gallery on another screen

(0) ShareShare
ReportReport
Posted on by 97

PowerAppExample.png

 

Just as the title states. In the Microsoft Service Desk example app above, the first screen displays a group of filters (I assume). By selecting a filter, you move to a Gallery screen, where you can select a specific record to view details, etc. I am trying to recreate this in my app, filtering by dates, or possibly statuses. That shouldn't matter. Basically filtering on existing fields and data. 

 

I tried creating a button with a filter my first screen, with a Navigate command to the Gallery, either separate, or nested. But all it did was take me to the Gallery with no filtering. Does the scenario above actually use multiple Gallery screens, one for each predefined filter? Or, is there a formula that is actually being performed against a single Gallery. I would really like to understand how this works. Basically, creating a filter that takes you to a Gallery on another screen.

  • Verified answer
    JimmyS Profile Picture
    JimmyS 97 on at
    Re: Using multiple filters to control a Gallery on another screen

    Found the solution in the Forums. To create the above;

     

    ClearCollect(temp,Filter('YourDataSource',Tickets = "In Progress"));Navigate(BrowseScreen1, None)

     

    Where:

    "temp" is a temporary Collection (labeled temp) created within your app

    YourDataSource is the source name of your data (Excel, Sharepoint, etc)

    Tickets is a field within your table

    "In Progress" is one of the available parameters in that field

     

    On your Browse Screen/Gallery screen, be sure to change the name of your source in  Items to; SortByColums(Filter(temp, Starts with   etc.

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,526

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,907

Leaderboard