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

I have the same question (0)

All responses (5)

Answers (1)

Verified answer

v-jefferni on at

Like (1)

Report
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.

Was this reply helpful? Yes No
Powerapps_Dan 48 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report
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.

Was this reply helpful? Yes No
Powerapps_Dan 48 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
v-jefferni on at

Like (1)

Report
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.

Was this reply helpful? Yes No