Notifications
Announcements
Hi everyone!
in my CDS I have GPS point and I would like to create a flow that fill the zip code and the city in the same CDS.
How could I split zip code and city from the result of a "get location by point"?
kind regards
There is a variable that is returned for Postal Code.
You will need to do string manipulation for the City though.
Here is a quick reference: https://faustocapellan.com/2018/05/01/express-yourself-string-functions-in-microsoft-flow/
Hi @Kesh ,
Please try this configuration to get zip code and city name:
Expression reference:
trim(split(body('Get_location_by_point')?['name'],',')[1])
Hope it helps.
Best Regards,
hi @v-bacao-msft,
thank you for your answer,
I still have the zip code in the var, How could I remove it?
Please give an example of what values you need.
Regards,
for example, for the latitude : 48.85837 and longitude :2.294481 (eiffel tower)
the result of your expression is "75007 Paris" and I don't need the "75007 ". How could I remove that?
kind regards.
Try this expression:
trim(replace(trim(split(body('Get_location_by_point')?['name'],',')[1]),body('Get_location_by_point')?['address']?['postalCode'],''))
Thank you it works!!
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.
In our never-ending quest to improve we are simplifying the forum hierarchy…
We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Michael E. Gernaey 501 Super User 2025 Season 2
Tomac 323 Moderator
abm abm 237 Most Valuable Professional
