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)