You’re offline. This is a read only version of the page.
31
I'm facing multiple similar issues with the default "AAD Users" virtual table in canvas app and I'm wondering if anyone tried it and found any obvious solutions that I'm missing.
Most of the issues boil down to the fact that when collecting or setting a variable of a row from "AAD Users" it only retrieves the "DisplayName" and "AAD User id" columns and leaves the rest blank. Same goes when trying to see a property of a LookUp column directed at "AAD Users".
Examples
ClearCollect(colUsers, 'AAD Users')
(Trust me there's values behind the black boxes 😁 )
Now lets do the same with Filter.
ClearCollect(colUsers,Filter('AAD Users','Job Title' = "Development Department Manager"))
So the last row displayed in the previous image is there (you can tell it's the corect one by the aaduserid and the query matching the jobtitle) but now everything else is blank...
Another example, lets look at a gallery using a LookUp column to the "AAD Users" table.
Displaying the username, all good.
Displaying userid, all good.
Trying to show anything other than the displayname or aaduserid doesn't return any results.
While if you do a LookUp directly to the virtual table the values of all other columns show up.
And again doing the same thing with a variable returns everything as blank.
This is very frustrating and loses many of the functionalities a person column has in sharepoint. For example if I want to display the the Company of all the "Responsible Users" in my example above i'd have to put a label with
Office365Users.UserProfileV2(ThisItem.'Responsible User'.'AAD user id').companyName
which heavily impacts performance while normally it should be just
ThisItem.'Responsible User'.'.Company Name'
Similarly I can't use filter queries in galleries to hide rows based on company/department since that info always appears as blank.
I hope there's something very obvious I'm missing here otherwise it seems that this virtual table functions properly mostly on ModelDriven apps.
Can you please tell how you created your own AAD Users table using Power Automate and Office 365 actions?
Can you guide with the connectors and steps?
I actually thought of this and gave it a test but it takes about 1second to get the user info using an O365 action and creating a new row in a custom dataverse table. Seeing how we work with tens of thousand of users in the tenant it would take many hours for this flow to run, if it even managed to as I expect throttling to kick in and the actions would take more time than 1 second/user since after the first run it would need to find the alredy existing row and update it instead of simply creating a new one.
I also find the AAD Users table very frustrating. I haven't come across your particular issue. However at times I have had to give up on the AAD Table and build my own AAD User table using Power Automate and the Office 365 Actions. I know its not as effective or efficient but I have much better control over the data.
---------------------------------------------------
Please Accept as Solution if it solves your question. Or just give it a Thumbs Up if it is helpful as can help others.
Subscribe: https://www.youtube.com/channel/UCFpvUlpx84FuIPOdInGKMTw
Twitter: https://twitter.com/assist_365
Regards
Darren Lutchner - 365 Assist
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
17
#3
ankit_singhal
11
Super User 2025 Season 1
Share
Report
All responses (
Answers (
