cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dalacarelia_196
Helper V
Helper V

Filter problem with StartWith

Hello 

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

 

11 REPLIES 11

Little confused about the colon 

 

Skola=ddskola.SelectedText.Value:

 

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

Skola=ddskola.SelectedText.Value;

This is how it is for us:

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

For you, it should be:

SortByColumns(
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.

Thanks!
Hardit Bhatia
The Power Addict
https://thepoweraddict.com

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,760)