Announcements
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
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 appAnd now i need to patch only city part out of that label text
What connector/data source are you using to display that information?
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
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.
Congratulations to our community stars!
Expanding mentorship, skilling, and AI innovation
These are the community rock stars!
Stay up to date on forum activity by subscribing.
11manish 382 Super User 2026 Season 2
Mohsin Ali 329
WarrenBelz 187 Most Valuable Professional