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

(0) Share

Report

Posted on by PAJ

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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

WarrenBelz 153,717 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
PAJ 280 on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
WarrenBelz 153,717 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

@PAJ ,

Sorry, best I can think of presently.

Was this reply helpful? Yes No