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
Go to Solution.
Here's how I would combine your 2 working FILTER functions.
Skola = ddSkola.SelectedText.Value;
StartsWith(Program; "E") Or StartsWith(Program; "S")
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."
View solution in original post
Learn how to create your own user groups today!
Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!
Check out the new Power Platform Community Connections gallery!