Hi all,
Currently using the Shoutouts canvas app and looking to filter out disabled users and users with certain text in their display name (admin users) from the search person screen.
I've tried adding Not(EndsWith(DisplayName,"TEXT")) and AccountEnabled to the existing code, but it's not working. I'm new to Power Apps, so I'm sure I'm just not adding it in the correct place.
Existing code:
If(IsBlank(Trim(SearchInputBox_4.Text)), MyRelevantPeople, Office365Users.SearchUser({searchTerm: SearchInputBox_4.Text, top: 20}))
Thanks in advance!
Solved! Go to Solution.
Hi @Powerapps_Dan ,
Please try this formula:
If(IsBlank(Trim(SearchInputBox_4.Text)),MyRelevantPeople,Filter(Office365Users.SearchUser({searchTerm:SearchInputBox_4.Text,top:20}),AccountEnabled= true ,Not(EndsWith(DisplayName,"TEXT"))))
Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
Hi @Powerapps_Dan ,
Please try this formula:
If(IsBlank(Trim(SearchInputBox_4.Text)),MyRelevantPeople,Filter(Office365Users.SearchUser({searchTerm:SearchInputBox_4.Text,top:20}),AccountEnabled= false ||Not(EndsWith(DisplayName,"TEXT"))))
Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
Hi @v-xiaochen-msft ,
Thank you! The filter on the ends with display name is working, however disabled accounts are still appearing unfortunately
Hi @Powerapps_Dan ,
Please change false to true in the image.
Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
hi @v-xiaochen-msft ,
Unfortunately changing from false to true isn't working either, this also stops the displayname filter from working too
Hi @Powerapps_Dan ,
Please try this formula:
If(IsBlank(Trim(SearchInputBox_4.Text)),MyRelevantPeople,Filter(Office365Users.SearchUser({searchTerm:SearchInputBox_4.Text,top:20}),AccountEnabled= true ,Not(EndsWith(DisplayName,"TEXT"))))
Best Regards,
Wearsky
If my post helps, then please consider Accept it as the solution to help others. Thanks.
User | Count |
---|---|
126 | |
87 | |
85 | |
75 | |
69 |
User | Count |
---|---|
215 | |
180 | |
139 | |
97 | |
83 |