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

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 III
Super User III

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 III
Super User III

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

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
PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

secondImage

Demo Extravaganza is Back!

We are excited to announce that Demo Extravaganza for 2021 has started!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

Power Apps June 2021

June Power Apps Community Call

Don't miss the call this month on June 16th - 8a PDT

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