Answered

Office365Users objects and questions

(0) Share

Report

Posted on by Community Power Pla... Microsoft Employee

I am building an object to use in my training exercise. I have the following.

Set(
 userObj,
 {
 Profile: Office365Users.MyProfile(),
 Picture: Office365Users.UserPhoto(User().Email),
 Manager: Office365Users.Manager(User().Email),
 isManager: Office365Users.SearchUser({searchTerm: 
 Office365Users.Manager(User().Email).DisplayName})
 }
);

When I insert a label and try to reference isManager(ie.. userObj.isManager) it says "Expected Text Value". So I'm trying to figure out how to convert that here for one.

Second, if I run this command in my label.
First(Office365Users.SearchUser({searchTerm: Office365Users.Manager(User().Email).DisplayName})).DisplayName

I get a value, however if I add the First() in my userObj it does not work. Can someone help understand what I'm doing wrong?

Categories:

Building Power Apps

I have the same question (0)

All responses (5)

Answers (1)

Sort by

Al_10 1,691 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

What if you try:

Set(
userObj,
{
Profile: Office365Users.MyProfile(),
Picture: Office365Users.UserPhoto(User().Email),
Manager: Office365Users.Manager(User().Email),
isManager:
First(Office365Users.SearchUser({searchTerm: Office365Users.Manager(User().Email)})).DisplayName
}
);

label = userObj.isManager

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!

the Set doesn't like it, it says "The function SearchUser has some invalid arguments.

Was this reply helpful? Yes No
Al_10 1,691 Super User 2024 Season 1 on at

Like
a
(0)

Report
Copy link

Link copied!

Set(varCurrentUserEmail, User().Email);
Set(
userObj,
{
Profile: Office365Users.MyProfile(),
Picture: Office365Users.UserPhoto(varCurrentUserEmail),
Manager: Office365Users.Manager(varCurrentUserEmail),
isManager:
First(Office365Users.SearchUser({searchTerm: Office365Users.Manager(varCurrentUserEmail).Mail})).DisplayName
}
);

label = userObj.isManager

edited

Was this reply helpful? Yes No
Community Power Pla... Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
@Anonymous Try this..

Set( userObj, { Profile: Office365Users.MyProfile(), Picture: Office365Users.UserPhoto(User().Email), Manager: IfError(Office365Users.Manager(User().Email),Blank()), isManager: CountRows(Office365Users.DirectReports(Office365Users.MyProfileV2().id)) > 0 } );

To reference the use's manager, use this (since you're setting Manager to the Manager object.

userObj.Manager.DisplayName

---
If this answered your question, please click "Accept Solution". If this helped, please Thumbs Up.

Was this reply helpful? Yes No
Verified answer

v-xida-msft Microsoft Employee on at

Like
a
(0)

Report
Copy link

Link copied!
Hi @Anonymous ,

What value do you want to store within the isManager column? Text value or Boolean value?

Do you detect if current user is also a Manager?

If you just want to store the retrieved "DisplayName" value into the isManager column, please modify your formula as below:

Set( userObj, { Profile: Office365Users.MyProfile(), Picture: Office365Users.UserPhoto(User().Email), Manager: Office365Users.Manager(User().Email), isManager: First(Office365Users.SearchUser({searchTerm: Office365Users.Manager(User().Email).DisplayName})).DisplayName } );

If you want to detect if current user is also an Manager, you need to store a Boolean value in the 'isManager' field. You need to modify your formula as below:

Set( userObj, { Profile: Office365Users.MyProfile(), Picture: Office365Users.UserPhoto(User().Email), Manager: Office365Users.Manager(User().Email), isManager: If( !IsEmpty(Office365Users.DirectReportsV2(User().Email).value), true, false ) } );

Then within your canvas app, you could reference the isManager column value through the following formula:

userObj.isManager

Please try above solution, then check if the issue is solved.

Regards,

Was this reply helpful? Yes No