Unanswered

Filter search items

(0) Share

Report

Posted on by Deggenau

Hello all!

I am creating app to search in a SharePoint list. The app is working fine but I need to add one more feature I cannot figure out.

This is the current code for the gallery:

SortByColumns(
Filter(
[@Materialliste],
TextSearchBox1.Text in Materialnummer ||
TextSearchBox1.Text in Bezeichnung ||
TextSearchBox1.Text in SLOC ||
TextSearchBox1.Text in WE
),
"Title",
If(SortDescending1, SortOrder.Descending, SortOrder.Ascending)
)

I can search for all of the four above items (Materialnummer, Bezeichnung, SLOC, WE) but I have some items in the list, that use the same Materialnummer (Material Number), so I want it to filter with the WE number descending.

Does somebody have a tip for me to filter this?

Thanks:)

Categories:

Building Power Apps

All responses (3)

Answers (0)

Sort by

WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

@Deggenau ,

Filter will return all matching Items (LookUp returns the first matching record). You can easily simply change the sort to this field (what exactly do you want to see in the returned items)
Deggenau 23 on at

Like
a
(0)

Report
Copy link

Link copied!

So basicly when i look for Material number 12345 and i have 3 items with the same material number, I want to see the items filtered descending by WE number.
WarrenBelz 156,545 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!
@Deggenau ,
As I noted, change this

"Title", If(SortDescending1, SortOrder.Descending, SortOrder.Ascending)

to this

"Materialnummer", SortOrder.Decending

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

MVP (Business Applications) Visit my blog Practical Power Apps