Hey @RezaDorrani ,
I found a solution but I willl still try yours!
Thank you so much,
Andy.
Filter( Office365Users.SearchUser( { searchTerm: txtInputEmployee.Text, top: 500 } ), Not("User Name" in DisplayName), AccountEnabled = true, If( Len(Department) < 1, Department = ddDepartment.Selected.Value, true ), If( ddDepartment.Selected.Value <> "", Department = ddDepartment.Selected.Value, true ), If( Len(Mail) > 1, true ) )
User | Count |
---|---|
139 | |
132 | |
75 | |
72 | |
68 |
User | Count |
---|---|
213 | |
200 | |
64 | |
62 | |
54 |