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?
Solved! Go to Solution.
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.
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.
oh my god, sometimes when you get buried in the weeds you miss seeing the picture.
thank you
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?
User | Count |
---|---|
229 | |
99 | |
95 | |
56 | |
33 |
User | Count |
---|---|
280 | |
110 | |
109 | |
64 | |
62 |