cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Ptiwari
Level: Powered On

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
Dual Super User
Dual Super User

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.
Ptiwari
Level: Powered On

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.

Dual Super User
Dual Super User

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.
Ptiwari
Level: Powered On

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors (Last 30 Days)
Users online (6,103)