Answered

Startswith Function Only Sorting on the First of Three Filter Criteria In My Gallery

(0) Share

Report

Posted on by mkusler

237

I have a gallery that pulls in data from my SharePoint List if a record is in one of 3 different "Quote Status". From there I am attempting to give the user the ability to further search those results by "ATI Freight PO#".

The problem is, my search function only works on the first "Quote Status" that I have in my code, which in this case is "In Transit".

Here is what I have in my Items Property, what am I doing wrong?

SortByColumns(Filter('Air Freight: Request & Tracking Log', (StartsWith('ATI Freight PO#', FreightPOSearchInput.Text)) && 'Quote Status'.Value = "In Transit" || 'Quote Status'.Value = "Pending Pickup" || 'Quote Status'.Value = "Quoting"),"Title", Descending)

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
@mkusler

Your punctuation is messed up. Try

SortByColumns( Filter( 'Air Freight: Request & Tracking Log', StartsWith( 'ATI Freight PO#', FreightPOSearchInput.Text ), Or( 'Quote Status'.Value = "In Transit", 'Quote Status'.Value = "Pending Pickup", 'Quote Status'.Value = "Quoting" ) ),"Title", Descending )

Was this reply helpful? Yes No
mkusler 237 on at

Like (0)

Report
Copy link

Link copied!

Thank you so much! That worked perfectly.

If in the future I wanted to add more "StartsWith" functions to give the user the ability to search by other criteria, is that possible or does having multiple functions like that cause confusion?

For example, if I wanted them to be able to search by "Quote #"?

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@mkusler

It is a bit more complicated but it can be done. Think of it as starting will a big table and filtering it down to a smaller one using the "And" operator to add additional criteria.

Was this reply helpful? Yes No
Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!

@mkusler

It is a bit more complicated but it can be done. Think of it as starting will a big table and filtering it down to a smaller one using the "And" operator to add additional criteria.

Was this reply helpful? Yes No
mkusler 237 on at

Like (0)

Report
Copy link

Link copied!

Awesome! I will see if I can figure it out on my own, now that I have a functioning gallery now.

Appreciate the proofreading!

Was this reply helpful? Yes No