Applying multiple filters to canvas app gallery

[Lily_Chen]

Hi, 

I am trying to fulfill the requirement: View a list of animals at the selected local shelter that are ready to be fostered.
And I need some help identifying what's wrong with my fx formula.

I set up a drop down list called"Select local shelter name" as one of the filtering metric. 

And below is the fx formula I have for now. It doesn't work.

Filter(Animals,

And('Shelter Status (Animals)'.'Ready for Foster'),('Shelter Name'='Select local shelter name'.SelectedText.'Shelter Name'))

Thank you for any solutions.

[BCBuizer]

Hi @Lily_Chen ,

I see you are using the SelectedText property which is actually deprecated. Instead you should use the Selected property:

Filter(
    Animals,
    'Shelter Status (Animals)'.'Ready for Foster'),
    'Shelter Name'='Select local shelter name'.Selected.'Shelter Name'
)

[Grkm_A]

Hi,

I have a solution for the filtering with 2 values in gallery. I used the formula that shown below and it worked. 

Filter(

    Animal_Details, // Table that the data shown and applying filters

    NewShelterName = SheltersDropDown.SelectedText.Value, // Dropdown item which selected form the drowdown item name as SheltersDropDown

    Text(NewShelterStatus) = "Ready for Foster" // ShelterStatus is Ready for Foster i the another filtering value

)

[Lily_Chen · Accepted solution]

Hi Thank you for helping me debug!

@BCBuizer The formula still doesn't work but at least now I know I should use "Selected" instead!

@Grkm_A I think your code looks correct and I did tried, but it says"Delegation warning. The "Text" part of this formula might not work correctly on large data sets."

But good news, in the end I got things right with the method in this video:

https://youtu.be/5dSk5iOgT68?si=WQgeLJfm33n3OPKM

Now my code looks like this:

Filter(

    Animals,//The table that contains all the animal information

    'Shelter Name' = 'DD shelter name'.Selected.'Shelter Name',//Dropdown item which selected from the drowdown item named as "DD shelter name"

    'Shelter Status' = 'CB shelter status'.Selected.Value//Combo Box item which selected from the Combox Box item named as "CB shelter status"

)

P.S. I deselected the "allow multichoice selections" in the property setting.

[Grkm_A]

Hi @Lily_Chen ,

Yes, I saw that error too. However, since only one "shelter status" was required in the pdf file, I added it as a constant to the formula. Although we can multiply this as a list. (Text(NewShelterStatus) in ["filter1","filter2"... ]) I think the error is caused by setting this variable as constant.

Also, if I understand correctly, only those with shelter status "ready for foster" will be listed?

[GeekSkier]

Hi - you can also do it without filtering. This is how I did it...

• Over in my Animals table, I created a new view called 'Ready for Foster'. The VIEW is filtered so it only shows animals with that status.
• Then, when I created my gallery, I set the datasource to the Animals database and the VIEW to the view I created.