cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper III
Helper III

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
Highlighted
Community Champion
Community Champion

Re: Filter problem with StartWith

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
Highlighted
Community Champion
Community Champion

Re: Filter problem with StartWith

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

Highlighted
Helper III
Helper III

Re: Filter problem with StartWith

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

 

Highlighted
Community Champion
Community Champion

Re: Filter problem with StartWith

You are welcome  - happy to help

Highlighted
Helper III
Helper III

Re: Filter problem with StartWith

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

 

 

Highlighted
Super User
Super User

Re: Filter problem with StartWith

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
Highlighted
Community Champion
Community Champion

Re: Filter problem with StartWith

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

     )
)

Highlighted
Helper III
Helper III

Re: Filter problem with StartWith

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

Highlighted
Super User
Super User

Re: Filter problem with StartWith

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
Highlighted
Community Champion
Community Champion

Re: Filter problem with StartWith

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
Check this Out

Helpful information

Featuring samples like Return to the Workplace and Emergency Response Applications

August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,879)