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.
