Showing results for 
Search instead for 
Did you mean: 
Post Patron
Post Patron

Filter problem with StartWith


I am trying to filter my sharepoint listbox and i need it to 

First select my schoolidnr  ( Kostnadsställe="1003" ) i works and when i use 

Filter( tblProgram; StartsWith(Program; "E") Or StartsWith(Program; "S")).Program it works 


But mixing them no good result , my wish is to see programs with name starting on E or S only in shool nr 1003 


This is one of lots of combos i have trying with no good result , is it possible to make this filter 

Filter(tblProgram;Kostnadsställe="1003") && Filter(tblProgram; Or StartsWith(Program; "E" Or StartsWith(Program; "S")).Program



Little confused about the colon 




I am from sweden and we are using ; instead of , crazy but life is like that for us . 

Is it ; is : instead of lie the OR with parallell signs


This is how it is for us:

Filter(tblProgram, Skola=ddskola.SelectedText.Value, (StartsWith(Program, "E") || StartsWith(Program, "V"))), "Program", If(SortOrderVariable, Ascending, Descending))

For you, it should be:

Filter(tblProgram; Skola=ddskola.SelectedText.Value; (StartsWith(Program; "E") || StartsWith(Program; "V"))); "Program"; If(SortOrderVariable; Ascending; Descending))

That was my mistake. I had a colon instead of a semicolon.

Let me know if this works.

If you like this reply, please give kudos. And if this solves your problem, please accept this reply as the solution.

Hardit Bhatia
The Power Addict

Helpful resources

Power Apps News & Annoucements carousel

Power Apps News & Announcements

Keep up to date with current events and community announcements in the Power Apps community.

Community Call Conversations

Introducing the Community Calls Conversations

A great place where you can stay up to date with community calls and interact with the speakers.

Power Apps Community Blog Carousel

Power Apps Community Blog

Check out the latest Community Blog from the community!

Top Solution Authors
Top Kudoed Authors
Users online (3,571)