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 / Capture City from Address
Power Apps
Answered

Capture City from Address

(0) ShareShare
ReportReport
Posted on by 776

Hi Experts,

 

Please guide me, how to capture city from the address

 

I want to patch the city name from address to sharepoint, 

 

which function or formula will always capture city out of the address

Categories:
  • zmorek Profile Picture
    3,272 on at

    The straight-forward way would be to have a separate field for the city, then patch that field to the City column in your SharePoint list.

  • AshishJaiswal Profile Picture
    776 on at

    @zmorek 

    User's address is already present in their address attribute.

     

    I'm using a label to display what is the address/location of the user when they open the app

    And now i need to patch only city part out of that label text

  • zmorek Profile Picture
    3,272 on at

    What connector/data source are you using to display that information?

  • Verified answer
    v-albai-msft Profile Picture
    Microsoft Employee on at

    Hi @AshishJaiswal ,

    Where do you get the address information? From Office365 or Azure?

    What 's the format of your address? Could you also give me an example about the address information?

    If you are getting information from Office365, you can directly use formula like this to get the city name:

    Office365Users.UserProfile(User().Email).City

    v-albai-msft_0-1620701987405.png

    v-albai-msft_1-1620702004412.png

     

    Best regards,

    Allen

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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Kudos to our 2025 Community Spotlight Honorees

Expanding mentorship, skilling, and AI innovation

Leaderboard > Power Apps

#1
11manish Profile Picture

11manish 382 Super User 2026 Season 2

#2
Mohsin Ali Profile Picture

Mohsin Ali 329

#3
WarrenBelz Profile Picture

WarrenBelz 187 Most Valuable Professional

Last 30 days Overall leaderboard