Enum list filter and order by person name


I am designing an app for my clients and they want to be able to submit work requests, either on their behalf or the behalf of someone on their team, they have a shared team email. They also only want the security of seeing only their team members names and the work tasks associated with their team, in first name alphabetical order.

I was able to write an expression that limits the names but the expression also displays their person id. I am not sure where I went wrong in my expression.

Is there a better way to write the expression where only the team names are returned in alphabetical order by first name without the person ids?

Any assistance would be a life saver.

My expression is: ORDERBY(FILTER(Person,[Email]=USEREMAIL()),[Person Name],FALSE)

Screen Shot 2021-03-08 at 1.55.17 PM



1 Like