![InvalidTemplate. Unable to process template language expressions in action 'Compose' inputs at line '1' and column '2469': 'The template language expression 'items('Apply_to_each')?['key1']' cannot be evaluated because property 'key1' cannot be selected. Array elements can only be selected using an integer index. Please see https://aka.ms/logicexpressions for usage details.'.](https://sharepains.com/wp-content/uploads/2018/11/invalidtemplate.png "invalidtemplate")
This post is all about unnecessarily complicated data structures like nested arrays with a single item in them. Nested arrays Example How often do you
Author: Pieter Veenstra
Is your business still running on paper trails, sprawling Excel files, or ageing Access databases? There's a better way — and I can show you exactly what it looks like.
I'm the Technical Director of Vantage 365, a Microsoft solutions consultancy working with clients across the UK, the Netherlands, and worldwide.
For over 30 years I've been turning messy, manual business processes into clean, automated systems that save time, reduce errors, and give teams the visibility they need to make better decisions.
SharePains is not just any blog run by a Microsoft MVP. Have you ever used Try-Catch in Power Automate? The original post about Try-Catch in Power Automate can still be found on this site, https://sharepains.com/2018/02/07/try-catch-finally-in-power-automate-flow/
Or have you ever used the Pieter’s method to avoid variables and speed up your flows? https://sharepains.com/2020/03/11/pieters-method-for-advanced-in-flows/
You can contact me using contact@sharepains.com
Quite a while ago when the modern libraries were introduced I already started to question the use of content types. In my post Are content types
Generate a date in your Flow Recently quite a few citizen developer asked me how to format dates in a flow in Power Automate. Quite
The SharePoint odata filter query in get items actions can optimize your flows in Power Automate. First collecting all items and then use conditional logic
Today I had a look at the button options in Microsoft Flow. I created a flow with Manually trigger a flow trigger with just one
Load More