web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / Microsoft365Users.Sear...
Power Apps
Unanswered

Microsoft365Users.SearchUserV2 - To Search for City in Profile

(0) ShareShare
ReportReport
Posted on by 78

I am trying to create a dropdown list with names of colleagues that work in a certain city (hardcoded).

So basically filtering all O365-records by city "Target City" and list their DisplayNames in a combobox or dropdown.

I have been using Microsoft365Users.SearchUserV2

 

I have no issue getting all me personal city information. Also searching for the city returns records but not with the Target City as city but in DisplayName or Name column.
I read that want to do is not possible as  SearchUserV2 does not search in the city field.

Is that still the case? If so, any idea for a workaround?
Thanks a lot

Categories:
I have the same question (0)
  • SBax Profile Picture
    1,348 on at

    Hi @Florida712 

     

    You are correct, the possible options for searching are user principal name and ID

     

    If you could find a way to return all users, you could use a filter() to return only those in the correct city.

     

    Let me have a play around in my environment and see what I can work out for you

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 545 Most Valuable Professional

#2
Haque Profile Picture

Haque 314

#3
Kalathiya Profile Picture

Kalathiya 234 Super User 2026 Season 1

Last 30 days Overall leaderboard