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