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.
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.
@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.
This works for me with JobTitle. Only users who have a job title will be displayed in the gallery.