Need assistance for filtering "shelter" and "ready to foster"

[Mike96]

Hello,

I'm having trouble filtering my gallery. I have a drop box for the shelter name choices. The first part of the filter works "Filter(Animals, 'Shelter Name'= Dropdown1.SelectedText.Value)"

However, I'm unable to get the second part working trying too many different ways. The second part is to filter, 'Shelter Status' = "Ready to Foster"

Filter(Animals,

'Shelter Name'= Dropdown1.SelectedText.Value,

'Shelter Status' = "Ready to Foster")

Any help would be great. Thanks.

[Corry · Accepted solution]

@Mike96,
You will need to reference the actual value of the choice and not the label.
'Shelter Status' = 333330005

You may use the following formula:

Filter(

            Animals,

            'Shelter Name' = Dropdown1.SelectedText.Value && 'Shelter Status' = 333330005

        )

You can get the values by looking at the column within the table.

I am using a different approach by using a collection, a variable and the switch method within the 'Items' property of my Gallery. Here is my approach to filter my gallery, as an example.

Switch(

    varTabSelected,

    1, SortByColumns(

        Filter(

            Animals,

            'Shelter Name' = "Hooves Haven Rescue Clinic" && 'Shelter Status' = 333330005

        ),

        "cr0f4_name",

        SortOrder.Ascending

    ),

[Mike96]

Thank you! I did that yesterday but it didn't work. Then i realized my values were like adopted: xxxxx1, claimed for adopted xxxxx2, etc... but ready to foster for some reason was like xxxxxxxxxxxx335. So some random number out of no where. I probably input in a number by mistake. Anyhow, I deleted the value and added back in the choice and it works! Thanks for the help. I spent countless hours on this error!!!

[Corry]

You are welcome @Mike9.

I understand the frustration that some of these formulas bring. I’m used to working with SharePoint lists and not Dataverse as a data source.