Answered

Exclude specific staff from a direct reports gallery

(0) Share

Report

Posted on by Power_Automater

351

I have a simple direct reports gallery created by setting the following variable:

Set(vardirectreport1,First(Office365Users.DirectReportsV2(varcurrentuser).value));

And then using this in the gallery Items:

Office365Users.DirectReportsV2(vardirectreport1.mail).value

I would like to be able to exclude specific staff listed in the direct reports gallery. I know the names of the staff I want to exclude (eg. "John Doe", "Jane Doe" etc) and I understand that I would need to use the filter function but I am just not quite sure how to put these 2 things together into a formula.

How could I achieve this?

Categories:

Building Power Apps

All responses (4)

Answers (1)

Sort by

Verified answer

v-xiaochen-msft Microsoft Employee on at

Like
a
(1)

Report
Copy link

Link copied!
Hi @Power_Automater ,

Please try this:

Filter(Office365Users.DirectReportsV2(vardirectreport1.mail).value,displayName<>"John Doe",displayName<>"Jane Doe")

Best Regards,

Wearsky
Power_Automater 351 on at

Like
a
(0)

Report
Copy link

Link copied!

Perfect thank you.

Can I ask, if I needed to reverse this in the future and only need to include "John Doe" and "Jane Doe" and exclude everyone else would this be easy to change in the formula you have provided above?
v-xiaochen-msft Microsoft Employee on at

Like
a
(2)

Report
Copy link

Link copied!
Hi @Power_Automater ,

This formula will help you

Filter(Office365Users.DirectReportsV2(vardirectreport1.mail).value,displayName="John Doe"||displayName="Jane Doe")

Best Regards,

Wearsky
Power_Automater 351 on at

Like
a
(0)

Report
Copy link

Link copied!

Thank you, I had everything right except the "||" instead of the "," and couldn't work it out 👍