Answered

PowerApps - Office365Users.DirectReports

(1) Share

Report

Posted on by LukasToman

I'm encountering an issue with the Office365Users.DirectReports function in my application. The error message states: "office365users.directreports failed: the function 'directreports' has an invalid value for parameter 'userid' - a blank value was passed to it where it was not expected. Please make sure that a valid argument is passed to the function."

To provide some context, I'm using a text field where the manager's email is entered, and the Office365Users.DirectReports function should return the direct reports

(Office365Users.DirectReports(Head_Department_Name.Value))

. The application runs fine, but this error appears during data loading, and I need to hide this notification.

Could anyone advise on how to prevent this error or hide the notification?

Thanks in advance for your help!

I tried to modify the following code but without success:

If (!IsBlank(ThisItem.CreatedByUser), Office365Users.UserProfile(ThisItem.CreatedByUser).DisplayName)

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (1)

Sort by

Verified answer

Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!
Hey @LukasToman ,

You can do it like this :

IfError(Office365Users.DirectReports(Head_Department_Name.Value),"")
This will hide the error message.

Was this reply helpful? Yes No
LukasToman 29 on at

Like (1)

Report
Copy link

Link copied!

Does'nt work 😞

Was this reply helpful? Yes No
Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like (1)

Report
Copy link

Link copied!

What is the error that it shows?

Was this reply helpful? Yes No
LukasToman 29 on at

Like (1)

Report
Copy link

Link copied!

Was this reply helpful? Yes No
LukasToman 29 on at

Like (1)

Report
Copy link

Link copied!

The expression was intended to retrieve the direct reports of the user whose department name is stored in the variable 'Head_Department_Name', and if there is an error, return an empty string. However, the errors indicate that the 'DirectReports' function is expecting a table value as an argument, not a text value, and the arguments provided to the 'IfError' function are invalid.

Was this reply helpful? Yes No
Daniel Bocklandt 5,151 Super User 2026 Season 1 on at

Like (2)

Report
Copy link

Link copied!
I just took a look at the connector:
IfError(Collect(colReports,Office365Users.DirectReportsV2(Head_Department_Name.Value)),"")
This code needs to be on a button (Navigate to the next screen or something like this) or on the onChange of your DroDown/Combobox. Make sure to use the new version of the action and put colReports in the control requested.

Was this reply helpful? Yes No
LukasToman 29 on at

Like (2)

Report
Copy link

Link copied!

Problem solved... thanks to your idea .... with small modify .... i set IfError to App > OnError adn now working 🙂 thanks

Was this reply helpful? Yes No