Orderby expression returning invalid slice data

[enandoh0]

I am referencing a Project table and limiting the data to return projects that only match the user email.
No problem with the slice.

The issue is when I attempt to order the drop down results alphabetically. The expression returns project IDs that don’t belong to the email I am using.

My order by formula is ORDERBY(Projects[Project ID],[Project Name],FALSE).

When I remove the orderby expression, the drop down list displays a list I expect but not on alphabetical order.

What am I missing?!
Screen Shot 2021-08-06 at 5.40.27 PM|690x354

[Marc_Dillon · Accepted solution]

Because you’re using the base Table “Projects” in your expression, instead of the Slice “Project Slice Email”.

Referencing a Column value in a Table, versus referencing ALL Column values in the entire Table Tips & Tricks 💡

Having answered this question about 1 million times now, I guess I should make a tips-and-tricks post about it. Expressions of the form Table[Column] return a List type data value that contains the values in Column for ALL records in the entire Table. Most likely, If I’ve referred you to this post, the answer to your question is simply to change it to just: [Column] One of the most common places I’ve seen new app builders use this, is within SELECT() expression, like: SELECT( Table[Col…