Trying to do a distinct on a gallery and also sort columns, can someone tell me what is wrong with my code

[NitroPepsi]

This is what I am posting in my items section of my gallery. But I dont know why It does not like it. 

SortByColumns(Distinct(Search('[incentive_test].[D_eTime]',TextSearchBox1.Text,
"Employee_Display_Name"), "Employee_Display_Name", If(SortDescending1, Descending, Ascending)))

[RandyHayes]

@NitroPepsi 

This seems like what you have posted in the other thread you have!

I will answer here and there...

Change your formula to:

SortByColumns(
    Distinct(
        Search('[incentive_test].[D_eTime]',
            TextSearchBox1.Text, "Employee_Display_Name"
        ), 
        Employee_Display_Name
    ),
    "Employee_Display_Name", 
    If(SortDescending1, Descending, Ascending)
)

You needed to supply the column you wanted to make Distinct.

I hope this is helpful for you.

[NitroPepsi]

See, I try the formula you posted above and it said that it is not valid. 

[Gochix]

Try:

SortByColumns(
    Distinct(
        Search('[incentive_test].[D_eTime]',
            TextSearchBox1.Text, "Employee_Display_Name"
        ), 
        "Employee_Display_Name"
    ),
    "Employee_Display_Name", 
    If(SortDescending1, Descending, Ascending)
)

Randy forgot about quotation marks for your distinct expression.

_____________________________________________________________________________________
Please give a thumbs up if I resolved your issue! Please click Accept as Solution to close the topic!

[phipps0218]

I have tested on my side and the following should work for you @NitroPepsi:

SortByColumns(
Distinct(
Search('[incentive_test].[D_eTime]',
TextSearchBox1.Text, "Employee_Display_Name"
),
"Employee_Display_Name"
),
"Employee_Display_Name",
If(SortDescending1, Descending, Ascending)
)

[NitroPepsi]

Thank you for your help, but when I put it in it did not work as planned. In particular, when putting in manually the Employee Display name came out as a datacard in stead of the regular variable from the table. The error it gives me is " The sortbycolumns has some invalid arguments" and also "The Employee Display name does not exist". But it does exist it is just beinging up the datacard tho. 

[NitroPepsi]

Thank you for your help, I keep getting an error but this time it tells me that the error is unexpected characters. The formula contains 'parenClose' where 'Eof' is expected. 

[RandyHayes]

@NitroPepsi 

 The formula you are using is incorrect, please use the following formula initially provided:

SortByColumns(
    Distinct(
        Search('[incentive_test].[D_eTime]',
            TextSearchBox1.Text, "Employee_Display_Name"
        ), 
        Employee_Display_Name
    ),
    "Employee_Display_Name", 
    If(SortDescending1, Descending, Ascending)
)

[phipps0218]

Please can you try this:

SortByColumns(
    Distinct(
        Search('[incentive_test].[D_eTime]',
            TextSearchBox1.Text, "Employee_Display_Name"
        ), 
        Employee_Display_Name
    ),
    "Employee_Display_Name", 
    If(SortDescending1, Descending, Ascending)
)