How do I sort the referrenced column? I have ...

[WhiteCrow_MD]

How do I sort the referrenced column? I have another table which requires data from another table, I wanted the drop down list to appear the latest entry. How can I do this?

[Aleksi_Alkio]

You can do that with the ORDERBY expression like ORDERBY(SELECT(TableName[KeyColumnName],TRUE),[TIMESTAMP],TRUE)

[Scott_Hall]

Used the ORDERBY expression in this thread to solve my problem. Thank you!

[WhiteCrow_MD]

I placed it on the ref and showed error.

[Aleksi_Alkio]

Would you please show that expression?

[Aleksi_Alkio]

Where did you put this formula?

[WhiteCrow_MD]

In the app formula box

[Aleksi_Alkio]

Change it to Valid_If

[WhiteCrow_MD]

Thanks it worked. one more question, I tried to make a slice with row filter. AND([Date of Admission]=Now()-1, [Time of Admission]>=“07:00:00”) added that expression but the value of 07:00:00 doesn’t seem to return as 7AM instead as 12/30/1899 7:00:00 AM")

thanks

[Aleksi_Alkio]

That’s the day number 0. Is your slice working correctly?

[WhiteCrow_MD]

not working properly, I tried to use the “TEST” Should have resulted as false

[Aleksi_Alkio]

Is your column [Time of Admission] a real Time field?

[WhiteCrow_MD]

extracted from Date of Admission

[Daniel_Tanguay]

Hi, I was wondering if I could inquire as to how I can reverse the sort? This works perfect for me but… it’s reversing and sorting highest to lowest. I need to sort lowest to highest. Thanks in advance.

[Koichi_Tsuji]

help.appsheet.com

ORDERBY()

Sort row references

Did you check this documentation? Simple toggle true / false within orderby expression to apply ascend/descend either way you want to order the list.