Hello
I'm looking to build a staff directory using Powerapps. I have got as far as creating a working directory by following this guide https://blog.pragmaticworks.com/create-an-employee-directory-in-powerapps The trouble is that it is including all of the shared mailboxes when I only want it to display the current employees. I thought I could get around this by adding a filter to only display results where a line manager has been assigned. I'm not quite sure how to edit my formula to exclude results where the line manager for a record is blank. This is what I have so far:
Filter(Office365Users.SearchUser({searchTerm:TextInput1.Text}),CompanyName="mycompany1",AccountEnabled=true)
I also want to include multiple company names but if I change the formula to look for CompanyName="mycompany1" or CompanyName="mycompany2" it doesn't like it. I have tried using OR and IF statements but I'm not quite sure how to do it so any suggestions would be much appreciated.