Combine Filter and Startwith i listbox

[dalacarelia_196]

Hello 

I am trying to filtering my listbox 

So far i cant see all the schools by idnr  "1003" and filtering out courses starting och E or S 

But not combined , Filter(klass ; Skola =ddSkola.SelectedText.Value; Program = Filter( tblProgram; StartsWith(Program; "E") Or StartsWith(Program; "S"))).Program

This is how i think it dosent work out maybee its not possible 

Works Code Filter(tblProgram;Kostnadsställe="1003").Skola

Works Code Filter( tblProgram; StartsWith(Program; "E") Or StartsWith(Program; "S")).Program

[mdevaney · Accepted solution]

@dalacarelia_196 

Here's how I would combine your 2 working FILTER functions.

Filter(
    klass;
    Skola = ddSkola.SelectedText.Value;
    StartsWith(Program; "E") Or StartsWith(Program; "S")
).Program

If Skola is a number it might be necessary to put this section of code inside the value function

Skola = Value(ddSkola.SelectedText.Value)

---
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."