SortByColumns Not Working (Multiple Errors)

[levoncosta]

Hello,

I'm getting a ton of errors when attempt to sort a screen by its date ('Date Work'). This will enable users to sort by most recent and oldest first. 

This is the Items property of the gallery: 

SortByColumns(
    Filter(
        [@'ERP Time Entry'],
        StartsWith(
            'Project Name',
            SelfSearchBox.Text
        ),
        Lower('Employee Email') = Lower(User().Email),
        'Date (Work)' >= RegularDatePickerFrom.SelectedDate,
        'Date (Work)' < DateAdd(RegularDatePickerTo.SelectedDate,1,TimeUnit.Days)
    ),
    'Date (Work)',
    If(sortDescendingSelf, SortOrder.Descending, SortOrder.Ascending)
)

This is the OnVisible property of the screen:

UpdateContext({sortDescendingSelf: false})

This is the OnSelect property of the sort icon:

UpdateContext({sortDescendingSelf: !sortDescendingSelf})

Any help is greatly appreciated. And kudos to you! 

[levoncosta]

@Jayaprakash 

Hi, you helped solve something similar earlier today. Would you mind taking a look here? 

[BCBuizer]

Hi @levoncosta,

When using the SortByColumns function, you need to provide the literal columnname, so with double quotes:

SortByColumns(
    Filter(
        [@'ERP Time Entry'],
        StartsWith(
            'Project Name',
            SelfSearchBox.Text
        ),
        Lower('Employee Email') = Lower(User().Email),
        'Date (Work)' >= RegularDatePickerFrom.SelectedDate,
        'Date (Work)' < DateAdd(RegularDatePickerTo.SelectedDate,1,TimeUnit.Days)
    ),
    "Date (Work)",
    If(sortDescendingSelf, SortOrder.Descending, SortOrder.Ascending)
)

[levoncosta]

@BCBuizer Even this did not work. 

[BCBuizer]

Hi @levoncosta ,

Let's see if the special characters in the column name cause the issue:

SortByColumns(
    Filter(
        [@'ERP Time Entry'],
        StartsWith(
            'Project Name',
            SelfSearchBox.Text
        ),
        Lower('Employee Email') = Lower(User().Email),
        'Date (Work)' >= RegularDatePickerFrom.SelectedDate,
        'Date (Work)' < DateAdd(RegularDatePickerTo.SelectedDate,1,TimeUnit.Days)
    ),
    "Date_x0020__x0028_Work_x0029_",
    If(sortDescendingSelf, SortOrder.Descending, SortOrder.Ascending)
)

If this doesn't work, please share the text of any errors you receive.

[levoncosta]

@BCBuizer 
I put in the code as you suggested, and the entire code is red with 2 primary errors. 

[BCBuizer · Accepted solution]

Hi @levoncosta ,

The issue is that the internal name of the column you wish to sort by is not correct. The internal name may be different from the display name ('Date (Work)'), which is causing the issue. 

To find the internal name of the column, in SharePoint go to list settings and then select the column. Once the screen with the column settings has opened, check the address bar and scroll all the way to the end. The you'll find the internal name, after "&Field=".

In the below example the internal name is 'Users':

[TheRobRush · Accepted solution]

This may sound stupid, but just humor me. Goto your splist, click gear in upper right, then list settings, now under columns find the one you are trying to sort by and click it. now at the top check how it appears behind field=, if its different than what you are referencing use that instead

[levoncosta]

@BCBuizer @TheRobRush You were both right and submitted within a minute of each other. The URL was "Date" not "Date (Work)". I'm quite devastated, and it's a little funny. I'm honestly unsure how to go about accepting who should have the solution here.

The final code was such:

SortByColumns(
    Filter(
        [@'ERP Time Entry'],
        StartsWith(
            'Project Name',
            SelfSearchBox.Text
        ),
        Lower('Employee Email') = Lower(User().Email),
        'Date (Work)' >= RegularDatePickerFrom.SelectedDate,
        'Date (Work)' < DateAdd(RegularDatePickerTo.SelectedDate,1,TimeUnit.Days)
    ),
    "Date",
    If(sortDescendingSelf, SortOrder.Descending, SortOrder.Ascending)
)

[TheRobRush]

you can accept as many solutions as you want haha