You’re offline. This is a read only version of the page.
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 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...
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?
@dpoggemann not what we need. we want a list of "active" AD accounts without having to disable users.
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.
#1
stampcoin
17
#2
ankit_singhal
11
Super User 2025 Season 1
#3
mmbr1606
9
Super User 2025 Season 1
Share
Report
All responses (
Answers (
