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?
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?
@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
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
@ANB when I added this
Filter(Office365Users.SearchUser({searchTerm:""}), AccountEnabled = true)
I was not able to see coworkers' names and my name.
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
@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?
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
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