web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Gallery filter - Filte...
Power Apps
Answered

Gallery filter - Filter to not see certain job roles

(0) ShareShare
ReportReport
Posted on by 1,154

Hi,

This is a continuation from a previous post I submitted but found / received a solution

Only to see those that had a certain domain name

Soultion - 

ClarkyPA365_0-1666623267645.png

I now need to exclude people with certain job Titles. I have a field ThisItem.Job Title.

How would I achieve this???

 

Categories:
I have the same question (0)
  • Akser Profile Picture
    1,546 Moderator on at

    You continue by adding another condition, no? JobTitle <> "Boss"

  • Chris1968 Profile Picture
    1,154 on at

    Hi @Akser 

    I'm wondering if there is another way that will do what is required by using the employeeID from the Attribute Editor 

    ClarkyPA365_0-1666624083004.png

    as these are unique to the job roles requiring to be excluded.  I do have a few.  

  • subsguts Profile Picture
    1,259 Moderator on at

    FYI:  Microsoft365Users.SearchUser is deprecated (still works currently, but maybe someday it will stop) so you should probably use Microsoft365Users.SearchUserV2.  I agree with Akser that you should be able to add multiple conditions on the Filter.  If not you can also embed filters, like Filter (Filter(....

  • Chris1968 Profile Picture
    1,154 on at

    Hi @subsguts 

    Getting error when I use the V2 version.

    Is there something I have to change as it seems it doesn't recognise Department, Mail and the filter formula as invalid argument types


  • Verified answer
    subsguts Profile Picture
    1,259 Moderator on at

    I had problems getting V2 to work as well.  Here is the discussion as hopefully this will help you too.

     

    Solved: Re: SearchUserV2 does NOT work with a ComboBox - Power Platform Community (microsoft.com)

  • Chris1968 Profile Picture
    1,154 on at

    Hi,

    That works fine for a Combo box which I do have within the app so made the changes and made sure Allow Search is active..

    Any idea of how to resolve the single search field??

    Edited at 16:48

    Ignore above comment sorted it😀

  • subsguts Profile Picture
    1,259 Moderator on at

    Can you explain what you mean by a "single search field".  I think with some additional info I can help you resolve this.

  • Chris1968 Profile Picture
    1,154 on at

    Hi,

    I have a txt field that that I search for a single person

    ClarkyPA365_0-1666626920684.png

     The Gallery Items formula is  

    ClarkyPA365_1-1666626992727.png

    Adding the 'value' expression works here also.  Just forgot to put in the comma

  • subsguts Profile Picture
    1,259 Moderator on at

    This statement doesn't work with the SearchUserV2, only with the SearchUser?

  • Chris1968 Profile Picture
    1,154 on at

    Hi,

    I'm using the SearchUserV2 in my formula with the ' .value'.
    It seems to be working with the filters being used..... 

    Would you know if it is possible to extract additional information from a user AD properties, such as Employee ID????

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.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Congratulations to the March Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 541

#2
WarrenBelz Profile Picture

WarrenBelz 434 Most Valuable Professional

#3
Valantis Profile Picture

Valantis 289

Last 30 days Overall leaderboard