web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Unable to filter AAD U...
Power Apps
Unanswered

Unable to filter AAD User table

(1) ShareShare
ReportReport
Posted on by 21

Use case: trying to use AAD User table as the datasource for a canvas-based app's dropdown control. The list shows all AD accounts by default. The AD-synched metadata doesn't seem to provide any useful data to use as a filter other than the "AAD User Account Enabled" column. This would work in many/most scenarios; however, in this case AD is synched to OnPrem so that toggle can't be turned off because the organization needs to keep former employee accounts enabled to maintain archival and delegated shared mailboxes.

 

Has anyone found a different way to filter this table? Or are we missing something given the constraint above?

I have the same question (0)
  • Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @JakeFarrell,

     

    You can utilize filter on the 'AAD Users' table like the following:

    Filter('AAD Users',StartsWith('Display Name',"Sven")) 

     

    Hopefully this can help you filter your list as needed.

  • jjfarrell Profile Picture
    21 on at

    @dpoggemann not what we need. we want a list of "active" AD accounts without having to disable users.

  • Drew Poggemann Profile Picture
    9,287 Most Valuable Professional on at

    Hi @JakeFarrell ,

     

    Sorry, I read in more detail and I understand your question.  @NHelgren , do you have any feedback on this one and how to filter as requested?

     

  • odrioll Profile Picture
    4 on at

    I agree with Jake that this table lacks filtering features that other tables have. I'd find useful to filter AADUsers by their email domain (endswith @foobar.com for instance?) or other fields like the accountenabled property. The systemusers table does not give the same information (nor the same amount of users) so I'm a bit stuck here...

  • jjfarrell Profile Picture
    21 on at

    We ended up creating a custom table (AAD Active Users) and synching data

  • odrioll Profile Picture
    4 on at

    I guess that could be a solution but I'd need to convice the Power App/Dynamics admin to do it (I only have read-only access to the tables)!

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 717 Most Valuable Professional

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 329 Super User 2025 Season 2

#3
Power Platform 1919 Profile Picture

Power Platform 1919 268

Last 30 days Overall leaderboard