Answered

Shoutouts Canvas App - Filter Disabled and Admin Users

(0) Share

Report

Posted on by Powerapps_Dan

Hi all,

I'm currently working on customising the Shoutouts Canvas app, and have noticed the search bar at the top of the app is returning disabled users when searching (at our organisation we do not delete accounts, we set them to disabled and change the display name to have "TERM - " at the front of it), also is returning results for our admin accounts (these have "_a" at the end of the username).

I'm wondering if there is a way to filter these results out easily?

Currently "items" on the search box is set to:

If(IsBlank(ComboBoxUserSearch.SearchText),
 Office365Users.SearchUser(),
 Office365Users.SearchUser({searchTerm: ComboBoxUserSearch.SearchText, top: 20})
)

Thanks for your help in advance!

Categories:

Building Power Apps

All responses (5)

Answers (1)

Sort by

Verified answer

v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Powerapps_Dan ,

Please try modify the code to:

If(IsBlank(ComboBoxUserSearch.SearchText), Filter(Office365Users.SearchUser(),AccountEnabled), Filter(Office365Users.SearchUser({searchTerm: ComboBoxUserSearch.SearchText, top: 20}),AccountEnabled) )

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Powerapps_Dan 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Hi @v-jefferni ,

Thank you so much! That worked perfect to remove disabled users!

Would there be a way to also filter out users that have "- Admin" in their display name?
v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Powerapps_Dan ,

You can add a condition in Filter functions:

EndsWith(DisplayName,"Admin")

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.
Powerapps_Dan 48 on at

Like
a
(0)

Report
Copy link

Link copied!

Edit: All good, Not(EndsWith(DisplayName,"Admin")) works perfect. Thanks for your help!

Hi @v-jefferni ,

That works to include users with "Admin" in their display name. Is there a way to exclude them?
v-jefferni Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Powerapps_Dan ,

You could add a "!" or use Not() function:

!EndsWith(DisplayName,"Admin")
Not(EndsWith(DisplayName,"Admin"))

Best regards,

Community Support Team _ Jeffer Ni
If this post helps, then please consider Accept it as the solution to help the other members find it.