Multiple Filteration

Org Chart Microsoft 365 version
1

Hi,

Just wanted to ask how can i get the following functonality:

I don’t want to show the users with empty hire date and also the users who don’t have deprtment classification.

I have tried the following code but it behaves as simple JS - if the user has hire date but no deprtment it shows him and he isn’t supposed to be shown.

return itemData["SPS-HireDate"] != "" || itemData["Department"] != "";

Do you have any idea?

Thanks,

David.

2

Hi David,
Thank you for the message.

If the user has hire date but no department, then your expression returns: true || false = true. And this user will be shown.

Try to use this expression:

return itemData["SPS-HireDate"] != "" && itemData["Department"] != "";

The result of this expression: true && false = false. And it will be true if hire date and department is not empty at the same time.

Best regards
Evgeniy Kovalev
Plumsail Team