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

Announcements

News and Announcements icon
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?

AADUserTable.png
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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the April Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
Vish WR Profile Picture

Vish WR 883

#2
Valantis Profile Picture

Valantis 571

#3
11manish Profile Picture

11manish 477

Last 30 days Overall leaderboard