cancel
Showing results for 
Search instead for 
Did you mean: 
Reply

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

 

1 ACCEPTED SOLUTION

Accepted Solutions
WarrenBelz
Super User
Super User

Hi @dalacarelia_196 ,

 

Try the filter below - some suggestions on the way I would approach it (and there are obviously other solutions):-

  • Bracket the Or items if they have to operate in conjunction with And
  • You can use || instead of Or
  • You do not need && - a comma in filter infers And
  • I have used commas as delimiters
  • I have trimmed the StartsWith statements down a bit

Filter(
     tblProgram,

     Kostnadsställe="1003",

     (

     StartsWith(Program, "E") ||

     StartsWith(Program, "S")

     )

)

View solution in original post

11 REPLIES 11
WarrenBelz
Super User
Super User

Hi @dalacarelia_196 ,

 

Try the filter below - some suggestions on the way I would approach it (and there are obviously other solutions):-

  • Bracket the Or items if they have to operate in conjunction with And
  • You can use || instead of Or
  • You do not need && - a comma in filter infers And
  • I have used commas as delimiters
  • I have trimmed the StartsWith statements down a bit

Filter(
     tblProgram,

     Kostnadsställe="1003",

     (

     StartsWith(Program, "E") ||

     StartsWith(Program, "S")

     )

)

Thanks this saves time for me i am so happy 4 this excelent solution 🙂

 

You are welcome  - happy to help

Hello again sir 

If i want the result of the program search to be A-Z or Z-A where to put the ;Ascending or Desc

 

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

 

 

Hi,

Would suggest creating a new thread for a new question. Here is a suggested approach.

You can use Sort or SortByColumns. Here is an example:

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

SortOrderVariable can be a context variable that toggles between true and false when the user clicks on the Sort icon.
UpdateContext({SortOrderVariable:!SortOrderVariable})

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

Hi @dalacarelia_196 ,

@PowerAddict was too quick for me here.

My response is almost exactly the same - I tend to prefer Sort if it works. Also toggle button is exactly what I use (I call it vSort).

 

Sort(

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

     If(
          vSort,

          Ascending,

          Descending

     )
)

Hello

 

If i understod  this right so i need a trigger 4 the sorting , is it not possible to force it to desc or asc

If you want either Ascending or Descending (and not both) you can do:

SortByColumns(
Filter(tblProgram; Skola=ddskola.SelectedText.Value: (StartsWith(Program; "E") || StartsWith(Program; "V"))), "Program", Ascending)

Let me know if this helps.

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

Hi @dalacarelia_196 ,

 

Absolutely - I just over-read it a bit

Sort(

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

          Ascending

)

Helpful resources

Announcements
Microsoft 365 Conference – December 6-8, 2022

Microsoft 365 Conference – December 6-8, 2022

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Difinity Conference 2022

Difinity Conference 2022

Register today for two amazing days of learning, featuring intensive learning sessions across multiple tracks, led by engaging and dynamic experts.

European SharePoint Conference

European SharePoint Conference

The European SharePoint Conference returns live and in-person November 28-December 1 with 4 Microsoft Keynotes, 9 Tutorials, and 120 Sessions.

Power Apps Ideas

Changes to Ideas Coming

We are excited to announce a new way to share your ideas for Power Apps!

Top Solution Authors
Top Kudoed Authors
Users online (4,039)