can i do sort inside sort of gallery?

[Anonymous]

Hi, i have question this is my code in gallery:

With(
    {
        _preFilter: Filter(
            TabCrysisSP,
            StartsWith(
                MCO,
                TextSearchBox2.Text
            ),
            StartsWith(
                'Type no',
                TextSearchBox4.Text
            ),
            IsBlank(ComboBox2_1.Selected.Result) || Vendor = ComboBox2_1.Selected.Result,
            IsBlank(ComboBox2.Selected.Value) || CFT.Value = ComboBox2.Selected.Value,
            IsBlank(ComboBox1.Selected.Value) || Status.Value = ComboBox1.Selected.Value,
            IsBlank(ComboBox3.Selected.Value) || Action.Value = ComboBox3.Selected.Value,
            IsBlank(ComboBox4.Selected.Value) || Criticality.Value = ComboBox4.Selected.Value
        )
    },
    SortByColumns(
        Filter(
            _preFilter,
            IsBlank(ComboBox4_1.Selected.Result) || 'Production Line' in ComboBox4_1.SelectedItems.Result,
            TextSearchBox1.Text in Item,
            ('Delivery date' >= DatePicker1.SelectedDate Or IsBlank(DatePicker1.SelectedDate)) And ('Delivery date' < DateAdd(
                DatePicker2.SelectedDate,
                1,
                Days
            ) Or IsBlank(DatePicker2.SelectedDate))
        ),
        "Created",
        If(
            SortDescending1,
            Descending,
            Ascending
        )
    )
)

and i mean this code exactly:

('Delivery date' >= DatePicker1.SelectedDate Or IsBlank(DatePicker1.SelectedDate)) And ('Delivery date' < DateAdd(
                DatePicker2.SelectedDate,
                1,
                Days
            ) Or IsBlank(DatePicker2.SelectedDate))

if someone type dates in this pickers, then can i sort result from earliest date to oldest?

[StalinPonnusamy · Accepted solution]

Hi @Anonymous 

We can try this

    "Created",
    If(
        !IsBlank(DatePicker1.SelectedDate),
        Descending,
        If(
            SortDescending1,
            Descending,
            Ascending
        )
    )

Thanks,
Stalin - Learn To Illuminate