Combining Multiple Direct Report Sources into a Single Listing

[RD94]

Hello,

I am using the Office365User connector and leveraging the DirectReports function. What I am looking to do is take the direct reports of Manager1 and append the direct reports of Manager2, to create a single listing of two different manager's employees. I am hoping to use this single list as the values of a combo box.

I've tried the following code in the 'Allowed Values' property without success.

[Office365Users.DirectReportsV2("Manager1@email.com").value, Office365Users.DirectReportsV2("Manager2@email.com").value]

Any suggestions?

Thank you,

Ryan

[rubin_boer · Accepted solution]

hi there @RD94 welcome to the community.

Try catching it all in a single collection ClearCollect(colBothManagers, Office365Users.DirectReportsV2("Manager1@email.com").value, Office365Users.DirectReportsV2("Manager2@email.com").value)

assign the colBothManagers to the Items of the combobox.

hope it helps