Filter Gallery based on dropdown

[mssss]

Hi,

Hello everyone,

I’m trying to Filter Gallery based on dropdown selection but not working.

Source of the dropdown list is CDS.

When I select Dropdown1.

I’d like to apply  filter to gallery.

Filter(budget,Dropdown1.Selected.Value in cm1a9_budgetcode)

Can someone please kindly help me? 

[mdevaney]

@mssss 

I think if you change the comparison operator to the equals sign it might work.

Filter(budget,Dropdown1.Selected.Value = cm1a9_budgetcode)

If you are still having an issue after trying my suggestion please tell me:

• What column type is cm1a9_budgetcode?
• Are there any errors showing?
• Can you send a screenshot of your app and workspace?

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

[mssss]

Thank you for your reply,

but still not working...

• What column type is cm1a9_budgetcode? :text
• Are there any errors showing? red underline to .Value =

Thank you so much for your help!

[mdevaney]

@mssss 

Please take a screenshot and share your full error message.

[mdevaney]

@mssss
I want to see the error message.

The PowerApps checker (top right menu) should have a red dot to indicate an error. Click there to find the error and please post a screenshot.

[mssss]

Sorry for my late reply.

My powerapps is not  English.

But it shows,OnSelect has no property.

dropdown,On Select Select(Parent) has red underline.

Thank you for your help!

[mdevaney]

@mssss 

Makes no difference to me if PowerApps is not in English.  The error message can be input into Google Translate if you tell me the original language.

[v-monli-msft · Accepted solution]

Hi @mssss ,

What is the data type of below field in the Value of drop down control?

Regards,

Mona