Filter problem with StartWith

(0) Share

Report

Posted on by dalacarelia_196

648

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

Categories:

Building Power Apps

All responses (11)

Answers (1)

Sort by

Verified answer

WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
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")
)
)
dalacarelia_196 648 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks this saves time for me i am so happy 4 this excelent solution 🙂
WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

You are welcome - happy to help
dalacarelia_196 648 on at

Like
a
(0)

Report
Copy link

Link copied!

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")
     )
)
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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
WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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
)
)
dalacarelia_196 648 on at

Like
a
(0)

Report
Copy link

Link copied!

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
PowerAddict 7,316 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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
WarrenBelz 156,536 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!

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
)
dalacarelia_196 648 on at

Like
a
(0)

Report
Copy link

Link copied!

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;