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 a gallery by ch...
Power Apps
Answered

Filter a gallery by choices based on a value selected in other gallery

(0) ShareShare
ReportReport
Posted on by 5

I have a Canvas app in which I want to filter a Gallery by a choices column.

The app is connected to 2 tables: Area and Checkpoints. The Area table holds a Choice column called Area_Zone_type and each area is assigned a Zone. The Checkpoints table holds a choices column called cp_Zone_type, because one Checkpoint can be assigned to many Zones and it hold a choices column for category since one Checkpoint can be assigned to many Categories as well.

 

Area Table (db_test_area)

Example

Area_name (Text)

Area 1

Area_zone_type (Choice)

Operational;Storage; Exterior

 

 

Checkpoint Table (db_test_checkpoints)

Example

Cp_name (Text)

Cp 1

Cp_zone_type (Choices)

Operational; Storage

Seyyid_0-1619450367507.png

 

I want to filter the checkpoint gallery by zone that is chosen in the area gallery. When I try to match the values power apps gives me an error that it cant convert the data type, from optionset to optionset. This is the formular I used:

Seyyid_1-1619450367514.png

 

Appreciate help and suggestions.

Categories:
  • Verified answer
    v-albai-msft Profile Picture
    Microsoft Employee on at

    Hi @Seyyid ,

    You can try this formula:

    Filter(db_test_checkpoints,Text(Gallery1.Selected.area_zone_type) in Concat(cp_zone_type.Value,Value&";"))

    Here is my test result:

    v-albai-msft_0-1619512903554.png

    Best regards,

    Allen

  • Seyyid Profile Picture
    5 on at

    hi,

    thanks a lot! 

  • v-albai-msft Profile Picture
    Microsoft Employee on at

    Hi @Seyyid ,

    If my solution is helpful to you, please mark my answer as a solution. This will benefit other community members who stuck with the same question.

    Thanks for your understanding.

    Best regards,

    Allen

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 220 Super User 2026 Season 2

#2
WarrenBelz Profile Picture

WarrenBelz 194 Most Valuable Professional

#3
Mohsin Ali Profile Picture

Mohsin Ali 150

Last 30 days Overall leaderboard