People Picker shows the AD disabled account.

(0) Share

Report

Posted on by happyyear

633

Hello All,

Can you do me a favor?

I'm utilizing SharePoint for the Power App form.

Is there a way to exclude disabled Active Directory accounts from appearing in the people picker when the form is created? Any formula or solution?

Categories:

Building Power Apps

I have the same question (0)

All responses (8)

Answers (1)

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

Hi @happyyear , You need to do a filter on AccountEnabled property to true.

-----------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

Thanks,
ANB

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report
Hi @happyyear Try this:

Filter(Office365Users.SearchUser({searchTerm:""}), AccountEnabled = true)

This should be on Item property of People picker which could be dropdown or combo box. Also before using this, make sure to add Office365Users connection.

------------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

Thanks,
ANB

Was this reply helpful? Yes No
happyyear 633 on at

Like (0)

Report

@ANB Thank you for your help.

This is a data card and I added the formula you gave and connected office 365 users to power apps.
But so far, It didn't work. Is there any way to make it work?

Was this reply helpful? Yes No
ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

Hi @happyyear , What is issue? I mean when you say did not work, then can you explain it? You need to have the fields to:
------------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

Thanks,
ANB

Was this reply helpful? Yes No
happyyear 633 on at

Like (0)

Report
@ANB when I added this
Filter(Office365Users.SearchUser({searchTerm:""}), AccountEnabled = true)
I was not able to see coworkers' names and my name.

Was this reply helpful? Yes No
Verified answer

ANB 7,223 Super User 2025 Season 2 on at

Like (0)

Report

Hi @happyyear , Did you saw my previous reply? For your data card where you are adding the above code, you need to check the field property as shown in below screenshot:

Also, do you see other names if not your and co-worker?

------------------------------------------------------------------------------------------------------------------------------

I hope this helps.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs up.

Thanks,
ANB

Was this reply helpful? Yes No
happyyear 633 on at

Like (0)

Report

@ANB Hello thank you for your help.

I will get back to you shortly. I need to check more. Thank you

Was this reply helpful? Yes No
happyyear 633 on at

Like (0)

Report

@ANB Yes, it worked. But there are other accounts, like group accounts, that need to be removed, but I don't know how to do it. Anyway, I was able to remove the disabled accounts. Thank you so much

Was this reply helpful? Yes No