How to query Azure Active Directory (AAD) from PowerApps Canvas app to show additional user properties.
Demo shows how to read “department” custom field from AAD for any user object by running PowerApps Custom Connector with MS Graph API query URL parameters. Cheers.
Video
Code
Set(department, 'PowerApps-QueryAzureAD'.GraphApiUser(TextInput1.Text, {'$select':"department"}).department)
Screenshots
References
- https://learn.microsoft.com/en-us/azure/active-directory/develop/quickstart-register-app
- https://learn.microsoft.com/en-us/connectors/custom-connectors/define-blank
- https://learn.microsoft.com/en-us/graph/api/resources/user?view=graph-rest-1.0
- https://stackoverflow.com/questions/48229949/get-all-user-properties-from-microsoft-graph