Column not recognized when working with tables

[oizaguir]

Hi everyone, 

I'm currenly struggle with a DataTable Items category, since I want to sort by a numeric column in descending order, but when sorting the items like this: 

SortByColumns(
    Filter(
        'Vacaciones SxH 2024',
        IsBlank(ComboBox1_2.Selected.Value) Or Supervisor.Value = ComboBox1_2.Selected.Value,
        IsBlank(ComboBox1_3.Selected.Value) Or TRIP.Value = ComboBox1_3.Selected.Value,
        IsBlank(ComboBox1_4.Selected.Value) Or SUBAREA.Value = ComboBox1_4.Selected.Value
    ),
    'Dias disponibles',
    SortOrder.Descending
);

 I get 'Dias disponibles' marked in red with an error that says: "Name isn't valid. 'Dias disponibles' isn't recognized."

If I cancel the SortBy() part and only add the filter part everything works fine...

Some details that may be important are that the Data comes from a Sharepoint list called 'Vacaciones SxH 2024' that has the mentioned column as a numeric column.

Any help will be really appreciated!

[Amik]

@oizaguir - could you replace 'Dias disponibles' with the Logical Name of that field and wrap it with double quotes. E.g.:

SortByColumns(
    Filter(
        'Vacaciones SxH 2024',
        IsBlank(ComboBox1_2.Selected.Value) Or Supervisor.Value = ComboBox1_2.Selected.Value,
        IsBlank(ComboBox1_3.Selected.Value) Or TRIP.Value = ComboBox1_3.Selected.Value,
        IsBlank(ComboBox1_4.Selected.Value) Or SUBAREA.Value = ComboBox1_4.Selected.Value
    ),
    "Diasdisponibles",
    SortOrder.Descending
);

Alternatively, intelli-sense should automatically provide you with a drop down of the appropriate syntax you need 

Image ref: https://learn.microsoft.com/en-us/power-platform/power-fx/reference/function-sort 

Further reading on Logical Names vs DisplayNames:

https://learn.microsoft.com/en-us/power-platform/power-fx/reference/operators 

[oizaguir]

Hi @Amik , thanks for responding, 

¿Where can I find the Logical Name of mi column? 

I already try to change the column name as: 

SortByColumns(
    Filter(
        'Vacaciones SxH 2024',
        IsBlank(ComboBox1_2.Selected.Value) Or Supervisor.Value = ComboBox1_2.Selected.Value,
        IsBlank(ComboBox1_3.Selected.Value) Or TRIP.Value = ComboBox1_3.Selected.Value,
        IsBlank(ComboBox1_4.Selected.Value) Or SUBAREA.Value = ComboBox1_4.Selected.Value
    ),
    "Dias_x0020_disponibles",
    SortOrder.Descending
)

as the SortByColumns() refence says and still the same...

[Amik · Accepted solution]

@oizaguir - go into the List settings and then select the field. You will find the Logical Name in the URL:

However, you should not need to do this because the column should appear intelligently as a selectable option in the dropdown menu when you write your formula.

[oizaguir]

Thanks @Amik ,

Worked great with the logical name 🤙