I have a strange problem with one of my flows. I have created another flow with Sharepoint as well as Outlook 365 and Approval connectors and everything is working fine (the flow hasn't run recently, since there is no new approval request though).
Now I have created another flow to check a list and send an email if a condition is met. However the flow aborts with the following error:
InvalidTemplate. Vorlagensprachausdrücke in den Eingaben der Aktion "E-Mail_senden" in Zeile "1" und Spalte "2427" können nicht verarbeitet werden: Der Vorlagensprachausdruck "json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$connections']['shared_office365']['connectionId']" kann nicht ausgewertet werden, weil die Eigenschaft "shared_office365" nicht vorhanden ist. Verfügbare Eigenschaften: shared_sharepointonline. Details zur Syntax finden Sie unter https://aka.ms/logicexpressions..
So, something about the connector not being available. A similar error is displayed when I tried to replace the email connector with an App notification event. I've read, that sometimes the connectors can be buggy (especially when triggered from BI) and removed and readded the connectors, but I am triggering the flow manually and nothing is working 😞
Has anybody had a similar problem?
Could you please share a screenhsot of the configuration of your flow?
Could you please explain more about the error message in english?
Could you please share the expression you used in the send an email action?
I afraid that the error message that you peovided told that the expression in the send an email action is wrong.
Please delete the expression in the send an email action to see if the issue still exists.
Please share more details so we would try to provide a proper workaround for you.
In the meantime I created the flow anew and there it seems to be working great. However it would still be great of course to get to the root of this problem.
The flow worked, when I deleted the step for sending an email.
While I am writing this post, the following happened: I had tried to run the flow and strangely got a similar error but some steps before, when I tried to get items of a Sharepoint list:
InvalidTemplate. Unable to process template language expressions in action 'Get_items' inputs at line '1' and column '2405': 'The template language expression 'json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$connections']['shared_sharepointonline_1']['connectionId']' cannot be evaluated because property 'shared_sharepointonline_1' doesn't exist, available properties are 'shared_sharepointonline'. Please see https://aka.ms/logicexpressions for usage details.'.
Before sending this post I tried to readd the step (Sharepoint - Get elements) which didn't work. But then I added a new connection with the same user in the step and strangely it worked - elements could be retrieved:
I tried the same with the email step - removed, readded, added another connection - but this didn't work.
The connector step seems to look for shared_office_365_2 but strangely ony a shared_sharepointonline connector seems available?
So, my guess is, that the configuration of Connectors is somehow messed up? If I recollect correctly, I created the flow on the go with my user (manfred.heimgartner), then later added "workflows" as an additional user and thus created a team flow and then changed the connectors to the workflows account.
Also, is this what you mean by "configuration of your flow"?
Fill out a quick form to claim your user group badge now!
We've given our badges an overhaul and also added some brand new ones!
Learn how to build the business apps that you need.
Find out where you can attend!
Watch & learn from the Power Automate Community Video Gallery!