cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
AshishJaiswal
Post Patron
Post Patron

Capture City from Address

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

1 ACCEPTED SOLUTION

Accepted Solutions
v-albai-msft
Community Support
Community Support

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

View solution in original post

4 REPLIES 4
zmorek
Super User
Super User

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.

@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
Super User
Super User

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

v-albai-msft
Community Support
Community Support

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

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Solution Authors
Top Kudoed Authors
Users online (1,542)