Filter, SortbyColumns, Search - Help

(0) Share

Report

Posted on by NitroPepsi

221

Hello,

I am trying to do a filter, sortbycolumns, search filter in my gallery but I can not seem to get it to work.

Filter(SortByColumns(Search('[incentive_test].[D_eTime]', 'Search Bar Table of Sub'.Text,"Employee_Display_Name"),"ImportMonth", Descending,"Employee_Display_Name",Ascending),DELETE_IND'.Value ="N")

I only want to show the those with the DELETE_IND'.Value ="N" I been messing with it and well I have not been successful.

Categories:

Building Power Apps

All responses (3)

Answers (1)

Sort by

Verified answer

RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(1)

Report
Copy link

Link copied!
@NitroPepsi

Please consider changing your Formula to the following:

SortByColumns( Search( Filter('[incentive_test].[D_eTime]', DELETE_IND'="N"), 'Search Bar Table of Sub'.Text, "Employee_Display_Name" ), "ImportMonth", Descending, "Employee_Display_Name",Ascending )

First, as with the last post, you have DELETE_IND as text. SQL does not have complex column types, so they would not have a .Value to compare to. Just compare the text.

Also, the order above is a little more "performance friendly" in that it first filters to only the records to search, then sorts only the records returned from the search.

I hope this is helpful for you.
NitroPepsi 221 on at

Like
a
(1)

Report
Copy link

Link copied!

Thank you so much, your formula worked perfectly!
RandyHayes 76,299 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

@NitroPepsi

Excellent! Happy to help! (and thank you for the coffee - love coffee!! ☕)