Flow not able to add any kind of location data to spreadsheet. ( Unable to process template language expressions in action)

[JamieF4T]

Hi,

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?

[abm]

Hi @JamieF4T 

Difficult to analyse without seeing your flow. This might be related to license according to this.

https://stackoverflow.com/questions/61519858/microsoft-flow-the-template-language-expression-cannot-...

Thanks

[abm]

Hi @JamieF4T 

If it doesn't related to license then please have a look at this post.

https://support.encodian.com/hc/en-gb/articles/360006399277-Fix-the-InvalidTemplate-Unable-to-proces...

Thanks

[JamieF4T]

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!

[JamieF4T]

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!!

[abm]

Hi @JamieF4T 

Are you running your flow from a smart phone?

Please have a look at this documentation

https://docs.microsoft.com/en-us/power-automate/introduction-to-button-trigger-tokens

Thanks

[JamieF4T]

Hi,

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.

[abm]

Hi @JamieF4T 

I did tried from my desktop and mobile. Same error. Looks like its broken. Thanks for the update.

[JamieF4T]

Hi,

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.

[JamieF4T · Accepted solution]

Microsoft have now fixed the problem and its all working again 🙂