Limit People Search to only show the same as User() Officelocation

[IndigoFaux]

On app start I am setting a variable for user location via:

Set(varUserLocation, Office365Users.UserProfile(User().Email).OfficeLocation)

Then in the people search I am using:

Filter(Office365Users.SearchUserV2({searchTerm:TextSearchBox2.Text, top:10}).value, OfficeLocation = varUserLocation)

It does not appear to be working, it's filtering something but it appears to be random? It does not show the proper people for the users location. Does anyone know how I can get this to work?

[cha_cha]

Hello @IndigoFaux 

Can't find fault in your code. Can you please confirm that Office Location is set in all the accounts?

[IndigoFaux]

Yes, office location is set for all users. Office location value shows up as Country/Airport code, so for example CA/YYC

[IndigoFaux]

If I switch the formula to:

Filter(Office365Users.SearchUserV2({searchTerm:TextSearchBox2.Text, top:10}).value, OfficeLocation = "CA/YYC")

It will show the correct employees, so is the issue with the variable not being recognized as text that matches?

[cha_cha]

Hello @IndigoFaux 

Use V2 for declaration:

Set(varUserLocation, Office365Users.UserProfileV2(User().Email).officeLocation);

Since Office Location is set manually in Azure, there might be causes that some may have extra spaces in their locations. 

Filter(Office365Users.SearchUserV2({searchTerm:TextSearchBox2.Text, top:10}).value, Find(varUserLocation,OfficeLocation))

You mention it works randomly. this happened to me today but with the Collect function. After clearing the cache and closing/opening all browsers, it worked fine for me. Can you please see if that works for you as well?

[IndigoFaux]

So it looks like with my original formula the people it was returning as results were those who do not have a location set.

I tried your formula, but it ends up returning all results, so the same as not filtering it seems like it doesn't recognize the search result OfficeLocation, it doesn't highlight it as a coloured value like the other triggers.

varUserLocation = OfficeLocation

[cha_cha]

If it's returning all results, then it means the varUserLocation was empty.

Try simulating an App.Onstart again and see what value is varUserLocation is getting.

Other than that, sorry, I'm out of ideas about what could be the probable cause. 

[IndigoFaux · Accepted solution]

I figured it out, instead of having the set variable on App/OnStart, I moved it over to the LoginScreen/OnVisible and it worked. For whatever reason when it was in OnStart it wasn't storing the variable.

Thanks for helping me hash it out to get to the answer 🙂