cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bennnnnn
Regular Visitor

How to filter gallery by combobox choices field

I am having trouble filtering my gallery by a combobox dropdown.

Using the images provided, can you let me know where I am going wrong please?

 

Filter: Error: Cannot use tables values in this context 

3.png

Choices:
1.png
Combobox options:
2.png

1 ACCEPTED SOLUTION

Accepted Solutions
v-qiaqi-msft
Community Support
Community Support

Hi @bennnnnn,

Do you want to filter the Gallery based on the multi select Choices field?

 

I have a test on my side, please take a try as below:

Filter(
    Pet2S,
    Concat(
        GenderTest.Value, //Here you should reference to the real field name in your Table
        Text(Value),
        ""
    ) in Concat(
        ComboBox4.SelectedItems,
        Text(Value),
        ""
    )
)

vqiaqimsft_0-1638862657893.png

 

Best Regards,
Qi

View solution in original post

2 REPLIES 2
WarrenBelz
Super User
Super User

Hi @bennnnnn ,

Can you please explain what you are trying to do here and also post the full Filter code (in Text)

v-qiaqi-msft
Community Support
Community Support

Hi @bennnnnn,

Do you want to filter the Gallery based on the multi select Choices field?

 

I have a test on my side, please take a try as below:

Filter(
    Pet2S,
    Concat(
        GenderTest.Value, //Here you should reference to the real field name in your Table
        Text(Value),
        ""
    ) in Concat(
        ComboBox4.SelectedItems,
        Text(Value),
        ""
    )
)

vqiaqimsft_0-1638862657893.png

 

Best Regards,
Qi

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,280)