Unanswered

textsearchbox exclude by value then search remaining items

(0) Share

Report

Posted on by RiKx

I'm trying to make my searchbox/gallery exclude all records based on a value (a status of completed) but search the remaining items (and ideally then order by a priority). However i managed to get just not completed items showing but cant get it to search as well.

Filter([@'Corrective Actions Register'], Status.Value <> "Completed" worked fine to just show the records but i can't get the search working...

SortByColumns(Filter([@'Corrective Actions Register'], Status.Value <> "Completed", StartsWith('CAR Number',TextSearchBox1.text)),"

any help greatly appreciated

TIA

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

Sort by

Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Hi,

Plz try this formula, Use (&&) instead of ( ,) may it works

SortByColumns(
Filter(
[@'Corrective Actions Register'],
Status.Value <> "Completed" && StartsWith('CAR Number', TextSearchBox1.Text)
))

Thanks!

If my response has been helpful in resolving your issue, I kindly request that you consider clicking "Accept as solution" and "giving it a thumbs up" as a token of appreciation.

Was this reply helpful? Yes No
RiKx 61 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi sadly not :(. same result

Was this reply helpful? Yes No
Rajkumar_M 3,747 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Plz try this

SortByColumns(
Filter(
[@'Corrective Actions Register'],
Status.Value <> "Completed" &&
StartsWith('CAR Number', TextSearchBox1.Text)),
"ColumnToSortBy", // Replace "ColumnToSortBy" with the actual column name you want to sort by

If(SortDescending, Descending, Ascending) // Replace "SortDescending" with a boolean variable or expression determining the sorting order

)

Thanks!

Was this reply helpful? Yes No