Power fx formula not working in Canvas App

[Paida]

Hi 

Please may you assist I used this formula in my Canvas App to filter the gallery:

Search('Animal Infos',Searchtxt.Text,'Shelter Name') but nothing happens.

I have tried all the other formulas that people have suggested but I keep getting errors.

Please help

[ZeeScience]

What exactly do you want the filter to do?

[Paida]

I am trying to filter ready to foster data on my gallery

[Corry]

Hi @Paida,

I personally am using a switch function with a sort by columns and filter but all you need is the following formula in the ITEMS property of your GALLERY. 

Filter(Table Name, 'Choice Column Name' = Value of the choice you are filtering on)

Filter(Animals,'Shelter Status' = 333330005)

You can get the choice values by selecting the column in the table, in your solution.

[ZeeScience]

Try this:

Search(Filter('Name of Animal Table', 'Name of Animal Table (Views)'.'Ready for Foster'), Name of Text Search Card.Text, 'Shelter Name')

[Paida]

Hi All 

I didnt see any error with both formulas but still no data 

[BCBuizer · Accepted solution]

Hi Everybody,

I see many different techniques being used to get the overview of all animals that are ready for adoption, so let me try to name and explain them a bit to provide some clarity.

To establish some commonalities: 

All methods apply to the Items property of a gallery to show all rows in the 'Animals' table that have a value in the Choice type column 'Shelter status' that indicates whether or not the animal is ready for adoption. Depending on the names you have chosen for the table or the column, you may need to change 'Animals' of 'Shelter status' in any of the given formulas.

1. Filter by Label

This is the method that is shown in the course videos when building a canvas app for the School Library solution. To use this, you need to apply a Filter function. In the condition of the function you select the 'Shelter Status' and compare that against a certain value. Assuming you are also using a choice set that is not synced with global choice, you can just type the name of the column again, followed by the label. In case spaces are included anywhere, the identifier needs to be wrapped in single quotes:

Filter(
    'Animals',
    'Shelter status' = 'Shelter status (Animals)'.'Ready to be fostered'
)

2. Filter by Value

As mentioned by @Corry , an alternative way of filtering is through the value where you don't use the Label of the Choice set, but the value. A downside of this is that these values are not descriptive, so you'll be forced to check you choice set often to check if you used the correct values, so that's why I recommend using option 1 over this option:

Filter(
    'Animals',
    'Shelter status' = 123456
)

3. Filter by View

The last option as mentioned by @ZeeScience is to filter by view. In this case you need to create a view for the Animals table in your solution that includes a filter to show only the animals that are ready for adoption. This can be done through the solution explorer in a similar fashion as in the course video for the School Maintenance app where a view is created for any outstanding issue. Once the view is created, you can use it as a condition in the Filter function in a canvas app:

Filter(
    'Animals',
    'Animals (Views)'.'Ready to be fostered view'
)

 In the above I first selected the views ('Animals (Views)') and then entered the name of the view to be applied ('Ready to be fostered view').

[Corry]

Thank you @BCBuizer for the comprehensive breakdown.

I went down the Filter by Value route as I was having difficulty with these formulas and the Filter by Value worked for me, so I stayed with it.

I have since updated my formulas to Filter by Label based on your guidance and it works perfect, thank you 😊

[ZeeScience]

@BCBuizer thank you for the extensive explanation it was really helpful

[J_Easter]

@BCBuizer This was such a detailed and helpful response. Do you have a breakdown similar to this for the Patch Formula. I have tried many combinations, and all end up in error.