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 / Filter gallery on two ...
Power Apps
Answered

Filter gallery on two values in a SharePoint column

(0) ShareShare
ReportReport
Posted on by 47

Hi everyone,

I have a power app to request inspections with the source a SharePoint list. I have a column called location. Due to a reorganization the location values / names have been changed. So, for example 

 

old valuenew value
garage 1garage external 1
office 1office external 1
office 2office internal 2

 

In the power app there is a gallery to filter all requests by location , the old location values will still be in the sharePoint list as well as the new. I have a dropdown to selecet the location, how can I filter the gallery on the new values and also old values? So if i choose location garage external 1 then it would also show garage 1 items also? Any help would be most appreciated. @WarrenBelz 

Categories:
I have the same question (0)
  • Mike2500 Profile Picture
    1,247 Super User 2024 Season 1 on at

    Is there a reason the list isn't being updated to fix the data? If you have a reasonable number of rows/locations, you can filter the list for "garage 1", and then use the grid view to update all rows to "garage external 1", and then repeat for other locations. Doing that would be far preferable to modifying an app to deal with old data. 

     

    Otherwise, perhaps you could create a list in sharepoint with two columns, the old and new location values. When the user picks an item from the dropdown (in the onchange event), you could run something like:

     

    Set(varOldLocation,LookUp(LocationList,Title=ddlLocationPicker.Selected.Value,OldLocation))

     

    You could then modify the gallery filter to use an OR to specify two conditions, where the location should be either the selected location or the value of varOldLocation.

  • Verified answer
    AndrewS Profile Picture
    47 on at

    @Mike2500  Thanks for the advice, Mike, i will check if the data can be fixed. Your other suggestion is good also as an alternative if they need to keep the old values for reporting 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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Congratulations to the July Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 429 Most Valuable Professional

#2
11manish Profile Picture

11manish 191 Super User 2026 Season 2

#3
MS.Ragavendar Profile Picture

MS.Ragavendar 122 Super User 2026 Season 2

Last 30 days Overall leaderboard