Dear experts, I added "All" in a dropdown value, the dropdown value is filtering based on logged-in User.
Below are the fourmla I used:
onStart ClearCollect(colDep,{Result: "All"}, If(User().Email in Filter(colUser, Department="96 Management").UserName, SortByColumns(Distinct(Expenses, Department),"Result"), Filter(Distinct(Expenses, Department), Result exactin colUser.Department)));
Note that the colUser I am using for another SharePoint list for the user's access level contains user Email and Department columns.
And for the dropdown Items I use colDep to filter the dropdown according to the above fourmla.
My question is how to remove the "All" value from the dropdown if the logged-in user not coming from the '96 Management' department.
Note that according to the fourmla above '96 Management' is for users who are able to see all departments, and other users see only the department they have access to, I want to remove "All" for the user who has access to 1 department only.
Thanks a lot for your help
