Filtering using Len in a gallery

[morall]

Works:

Sort(Filter('Pipeline Candidates', Len(Gallery1.Selected.'Candidate Summary')<50), 'Created On', Descending)

that works, but switching the sign to > doesn't

Doesn't work:

Sort(Filter('Pipeline Candidates', Len(Gallery1.Selected.'Candidate Summary')>50), 'Created On', Descending)

Any reason why?

[RandyHayes · Accepted solution]

@morall 

I'm not sure what you are trying to actually filter, but you are only basing your filter on ONE item.

    Sort(Filter('Pipeline Candidates', Len(Gallery1.Selected.'Candidate Summary')<50), 'Created On', Descending)

That one item is the value of the Candidate Summary of the currently selected item in your Gallery.

So, if that ONE item is a length of less than 50, then the result is true for every record.  If you switch the sign, the statement will evaluate to false...and you'll have no records.

I believe you want this instead:

Sort(Filter('Pipeline Candidates', Len('Candidate Summary')<50), 'Created On', Descending)

I hope this helps.

[morall]

oh my god, sometimes when you get buried in the weeds you miss seeing the picture. 

thank you

[morall]

when I try this with Sort() it works fine, but SortByColumns is throwing an error. In the suggestion box its suggesting using As, exactin, in and not <, > etc

SortByColumns(
    Filter(
        pipeline_candidates,
        Switch('Yrs of Exp drpdown'.Selected.Value,            
            "2-5 yrs", 'Years of experience' >= 2 && 'Years of experience' <= 5,
            "6-9 yrs", 'Years of experience' >= 6 && 'Years of experience' <= 9, 
            "10+ yrs", 'Years of experience' >= 10,
            true
        ) &&

        (search_box.Text in Name Or search_box.Text in 'Candidate Summary' Or search_box.Text in 'Candidate Details')

        && 

        PipelineTemplate.Name = 'pipeline drpdwn'.Selected.Result
        &&
        Switch(drpFastPass.Selected.Value, "Yes", Text(FastPass) = "Yes", "No", Text(FastPass) = "No", true)
        &&
        Len(pipeline_candidates.'Candidate Details') > 50  
        ## error is showing on the > symbol
        &&
        If(
            drpLocation.Selected.Value = "All", 
            true,
            drpLocation.Selected.Value in Concat('Desired Location'.Value, Value & ", "))
    ),
    "createdon",
    Descending
)

That makes me think Len(pipeline_candidates.'Candidate Details') is returning a list instead of a number?