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!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.