You’re offline. This is a read only version of the page.
Hello everyone,
I would have to write an expression that filters active users. Additionally, the user type should be "Guest" or have a specific name in the domain.
I can't get the "or" statement, including the active user expression
Currently my expression looks like this. Unfortunately, either guestuser or with the specific domain are output, but not both together. I have tried different expression configurations, the current one is wrong but it works
Share
Reportand(
equals(item()?['AccountEnabled'],true),
equals(item()?['UserType'], 'Guest'),
not(endswith(item()?['UserPrincipalName'], '@example.com'))
)
i also try this one:
and(
equals(item()?['AccountEnabled'],true),
endswith(item()?['UserPrincipalName'], '@example')
)
or(
equals(item()?['AccountEnabled'],true),
equals(item()?['UserType'], 'guest')
)
or this:
equals(item(?['AccountEnabled'], true)) and (endswith(item()?['UserPrincipalName'], '@example')), or (equals(item()?['UserType'], 'Guest'))
About Help I would be happy
Regards
#1
Michael E. Gernaey
497
Super User 2025 Season 2
#2
David_MA
436
Super User 2025 Season 2
#3
Riyaz_riz11
244
Super User 2025 Season 2
All responses (
Answers (
