Announcements
In a Canvas App is it possible to get a users Business Unit, Team etc... into the app?
For example if someone is in the "CorporationOne" business unit, can I get that information as a variable or part of a collection in the app?
Hi @lee-martin
What do you mean by "Business Unit"? If you want to save user's Department you can use the following code:
Set(varDepartment,First(Office365Users.SearchUserV2({searchTerm:"benjamin@golders.ch"}).value).Department)
King regards
Beny
@bengo83 -Thank you, but I'm asking about Business Units not the department.
In power apps admin, You can define Access through Security Roles, Teams, Users, and Business Units.
I want to be able to access those.
Ok, sorry... i know what you mean now 🙂
I think with the following code you can read out the bussiness unit from the current user of the app:
LookUp(Users,'Full Name'=User().FullName).'Business Unit'.Name
Users is a dataverse table where you need to add that the code works and for which you need a Powerapps premium licence.
I hope it helps you
@bengo83 - thanks, but we're not using dataverse
Does this mean, that you do not have premium licences? I don't think it would be possible to solve the problem in this case.
@bengo83
We have premier licenses. We are using SQL Server as our datasource
With premium licenses you can use the data table I recommend.
Best regards
So whatever we set in powerplatform admin - it will be in there?
I think you can find most of the informations in the dataverse (in different tables).
Best Regards
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 342 Super User 2026 Season 2
M Bilal Khan 271
Mohsin Ali 223
