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 / Filtering a gallery fr...
Power Apps
Answered

Filtering a gallery from a text control not working with SQL on Premise view loaded to a collection

(0) ShareShare
ReportReport
Posted on by 18

I have a canvas app with a tabs list that displays 1 of 3 possible galleries based on the selected tab list item. The 1st tab list item displays a gallery from a collection where the collection source is a dataverse table. The 2nd and 3rd galleries display a gallery from a collection that is sourced from a SQL on premise view. 

 

Above the galleries are text input controls that dynamically display data for filtering in the selected gallery using collections based on the tab list item selected. On select or on change the text input controls activate a button that performs the filtering.

 

The code on the button for filtering the galleries is as follows;

PowerApps Gallery Filtering .jpg

 

The text input control filtering works with the dataverse table when the tab list selection = "Benefit Sync". When tab list items "ERP Deductions" is selected, the correct gallery and text input controls are populated, however when the text input control selection is made the gallery is not filtered for the selection. 

 

I have checked that the column names for the filter of the collection and view are correct. I have also tested that I can filter that collection when it is created when the page is visisble. 

 

There is a delegation issue (both collections contain just under 2000 records), but the filtering is still occurring on the first gallery. 

 

What am I missing here? 

 

Categories:
  • Verified answer
    maggieS Profile Picture
    18 on at

    Solved it, bad coding my second if was nested inside my first. 😀

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 234 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 207 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 169

Last 30 days Overall leaderboard