cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper I
Helper I

Office 365 Search User Profile filter formula

We create a employee directory for our organization, we added office 365 connectors in this powerapps.

Our issue is in our office 365 we have service account and user profile both, we would like to show only User profile in the employee directory, but office 365 connectors showing everything (Service accounts and user profiles). What formula can be use to show only user profiles?  Currently we are using this formula.

Office365Users.SearchUser()

  

4 REPLIES 4
Highlighted
Dual Super User II
Dual Super User II

Re: Office 365 Search User Profile filter formula

You'll need to find some property that you can use to differentiate between regular users and service accounts.  Then use that property in a Filter() function to filter out the service accounts. I'm not aware of anything that would automatically remove them from the feed.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Helper I
Helper I

Re: Office 365 Search User Profile filter formula

@Pstork1 Thanks for the reply. I was looking the diffrence between the service account and the user profile.

Job title is added in the user profile but in service account job title value is blank, this is the only difference I find in these two accounts.

How can I write the formula that shows accounts only that has job title value not blank?

Any help is much appreciated.

Thanks again.

Highlighted
Dual Super User II
Dual Super User II

Re: Office 365 Search User Profile filter formula

This works for me with JobTitle.  Only users who have a job title will be displayed in the gallery.

Filter(Office365Users.SearchUser(),IsBlank(JobTitle)=false)



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Highlighted
Helper I
Helper I

Re: Office 365 Search User Profile filter formula

@Pstork1 Thank you, I am going to try that now.

I will update you the progress.

 

Helpful resources

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (4,748)