Hi, happy to help - filtering a gallery by a status value is a common one, so let's get it working.
The basic filter
The Filter function returns every record where your formula evaluates to true, so for a status column you'd point your gallery's Items to something like:
Filter(YourList, Status = "ABIERTO")
Filter evaluates the formula for each record and keeps the ones that come back true, and you can combine multiple conditions (they're joined with And). (Filter, Search, and LookUp functions)
If that returns nothing, check these (usually the culprit)
- Choice column: If "Status" is a SharePoint Choice column rather than plain text, you can't compare it to a string directly - you compare the
.Value, e.g. Filter(YourList, Status.Value = "ABIERTO").
- Exact text: A plain text match is case-insensitive but must otherwise match exactly - watch for trailing spaces or accents. You can also use the
in operator for a substring match, e.g. Filter(YourList, "ABIERTO" in Status).
- Right value: Make sure you're filtering on the value actually stored ("ABIERTO"), not a display label.
Tip if you see a delegation warning
If Studio underlines part of your formula with a delegation warning, the filter may only run over the first set of records rather than the whole list. Sticking to a simple = comparison on a delegable column avoids that. (Filter, Search, and LookUp functions)
If you can paste the exact formula you're using and confirm whether Status is a Text or Choice column, I can pinpoint it further.
Found this helpful? Please mark ✅ "Does this answer your question?" so others searching for the same issue can find it quickly. A 👍 on "Was this reply helpful?" or a ♥ Like is also much appreciated!
Raghav Mishra - LinkedIn | PowerAI Labs
