Sort/Filter not working as expected

(0) Share

Report

Posted on by aharsh

116

Hi,

I'm pretty new to PowerApps and I'm trying to do a basic Sort and Filter on a gallery. I looked through previous posts and based on what I've read, this should be correct, but I must be missing something.

The filter ws working before I wrapped it in a sort (I tried both Sort and SortByColumns with same error). I'm just trying to sort my results based on a date field in my list.

SortByColumns(Filter('Email Tracking', Status.Value <> "Complete")),'Send Date',Ascending)

I'm getting an "invalid number of arguments: received 1, expected 2 or more" error.

I'm not sure what else to try.

Thanks for any help!

Angie

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

Drrickryp Super User 2024 Season 1 on at

Like (1)

Report
Hi @aharsh

You have an incorrect syntax as a result of your formula.

SortByColumns(Filter('Email Tracking', Status.Value <> "Complete")),'Send Date',Ascending)

There is an extra ")" after Complete. An easy way to double check your formulas against this mistake is to count the number of "(" s and it should be the same as the number of ")"' s.

Was this reply helpful? Yes No
aharsh 116 on at

Like (0)

Report
Hi @Drrickryp , Thanks for your help!

I had actually tried all sorts of params, brackets, quotes, and commas before posting and nothing worked. The one you suggest (which is clearly correct - thank you) just gives me a different error, saying I have invalid arguments.

SortByColumns(Filter('Email Tracking', Status.Value <> "Complete"),'Send Date',Ascending)

This is my code. Email tracking is my list, complete is what I'm filtering by and send date is what I'm trying to sort by.

Still stumped.

Was this reply helpful? Yes No
aharsh 116 on at

Like (1)

Report

BAH - figured it out.

In this case "sort" worked, not "sortbycolumn".

Thank you!

Was this reply helpful? Yes No