I have a number of flows that record City and Postcode into a spreadsheet using an Instant Flow. These have all be working fine now for weeks without any issues.
About 2 days ago they all stopped working and give the following error:
Unable to process template language expressions in action 'Add_a_row_into_a_table' inputs at line '1' and column '2258': 'The template language expression 'triggerBody()['location']['address']['city']' cannot be evaluated because property 'address' doesn't exist, available properties are 'coordinates'. Please see https://aka.ms/logicexpressions for usage details.'.
I have no idea why this has suddenly broken across all types of device. The function it is looking to add is a full MS function for Instant Flow - City. (It doesn't work with any of the Postcode, State, Street, Full Address options).
Is this something that MS have broken? Any suggestions?
Solved! Go to Solution.
Difficult to analyse without seeing your flow. This might be related to license according to this.
If it doesn't related to license then please have a look at this post.
Thanks very much for the suggestions but it doesn't appear to be either of those.
I created a test flow as a very simple example:
When run, it creates the following error:
Its very weird as it was working perfectly and has been for a couple of months!
I should add that it can add all other types of data I can find to the table without issues, its just the location based stuff although it will write Longitude and Latitude!!
Are you running your flow from a smart phone?
Please have a look at this documentation
Had a support call with Microsoft late yesterday afternoon where they found that it didn't work on their systems either. Things went very quiet very quickly and the support guy got off the phone to escalate the issue in MS.
Looks like they broke something!
Will let you know what they come back with.
No problems, it looks like its quite a big issue, MS called back to say its now gone back to developers to look at and they hope to have something for early next week.
Its interesting that it wasn't picked up as its broken quite a few of their own templates.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.
At the monthly call, connect with other leaders and find out how community makes your experience even better.
If you are a small business ISV/Reseller, share your thoughts with our research team.