web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / I am facing an issue w...
Power Apps
Unanswered

I am facing an issue wherein my gallery takes a long time (or shows no items) to display data after filtering

(0) ShareShare
ReportReport
Posted on by 280

My gallery is getting filtered whenever modern tablist is clicked.

The filtering formula entered in items property is 

 

Filter(TicketTables,'Issue Type' = If(TabList1.Selected.Value = "Network",[@'Issue Type'].Network,TabList1.Selected.Value = "Software",[@'Issue Type'].Software,TabList1.Selected.Value = "Hardware",[@'Issue Type'].Hardware,TabList1.Selected.Value = "Security",[@'Issue Type'].Security,TabList1.Selected.Value = "Compatibility",[@'Issue Type'].Compatibility,TabList1.Selected.Value = "Data Migration",[@'Issue Type'].'Data Migration',TabList1.Selected.Value = "Performance",[@'Issue Type'].Performance,TabList1.Selected.Value = "Maintainence",[@'Issue Type'].Maintenance,TabList1.Selected.Value = "Other",[@'Issue Type'].Other))
 
Can it be simplified. 'Issue Type' column is a global choice column in dataverse table "TicketTables"

 

Categories:
I have the same question (0)
  • WarrenBelz Profile Picture
    154,494 Most Valuable Professional on at

    Hi @PAJ ,

    This will shorten it a bit

    Filter(
     TicketTables,
     'Issue Type' = 
     Switch(
     TabList1.Selected.Value,
     "Network",
     [@'Issue Type'].Network,
     "Software",
     [@'Issue Type'].Software,
     "Hardware",
     [@'Issue Type'].Hardware,
     "Security",
     [@'Issue Type'].Security,
     "Compatibility",
     [@'Issue Type'].Compatibility,
     "Data Migration",
     [@'Issue Type'].'Data Migration',
     "Performance",
     [@'Issue Type'].Performance,
     "Maintainence",
     [@'Issue Type'].Maintenance,
     "Other",
     [@'Issue Type'].Other
     )
    )

     

    Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

    MVP (Business Applications)   Visit my blog Practical Power Apps

  • PAJ Profile Picture
    280 on at

    I tried this way , but in mobile view , gallery remains stuck with an empty item , and when i click multiple times , the item appears, 

    Any tips on how i can make it smooth. 

  • WarrenBelz Profile Picture
    154,494 Most Valuable Professional on at

    @PAJ ,

    Sorry, best I can think of presently.

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 549 Most Valuable Professional

#2
Kalathiya Profile Picture

Kalathiya 225 Super User 2026 Season 1

#3
Haque Profile Picture

Haque 224

Last 30 days Overall leaderboard