Unanswered

Error in Flow

(0) Share

Report

Posted on by v-japrav Microsoft Employee

Hi,

we have a Flow which uses Outlook email, SQL Execute Procedure and O365 connectors. The flow was working untill last week. The connection used in the flow are valid and I don't see any issue with the connections. We are getting following error

Unable to process template language expressions in action 'Send_email_with_options' inputs at line '1' and column '1971': 'The template language expression 'json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$connections']['shared_office365_2']['connectionId']' cannot be evaluated because property 'shared_office365_2' doesn't exist, available properties are 'shared_office365, shared_sql_1, shared_office365groups, shared_sql'. Please see https://aka.ms/logicexpressions for usage details.'.

Is there anyone facing this issue or have any resolution/fix.

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

v-monli-msft on at

Like (0)

Report

Hi @v-japrav,

Would you please share the detailed configuration about your flow? Especially the parts related to property 'shared_office365_2'.

Is it a user group name? Please check if there is any changes about this user group in Azure AD.

Also, navigate to My connections list in Flow, and check on the status of the related connections:

https://docs.microsoft.com/en-us/flow/add-manage-connections

For future flow cases, please post in Flow community:

https://powerusers.microsoft.com/t5/Microsoft-Flow-Community-Boards/ct-p/MSFlowCommunity

Regards,

Mona

Was this reply helpful? Yes No
Pat-McClellan 2 on at

Like (0)

Report
I ran into this problem several times. Usually this happens to flows with a Power Apps trigger, and removing the Power Automate from the Power Apps Action and re-adding it and copying over the OnSubmit code fixes the problem, but in my most recent case this was not an option because the Power App is currently being updated with new code and features that have been requested by the stake holders, but not yet approved to go live, and the live version is older than 6 months, so I can't publish the currently saved Power App, and and can't restore the currently live App and re-publish that.

The solution I finally found to work is this:
If you click the three dots on the right you can select "Peek Code"
If you peek code you will see something like this:

{
    "inputs": {
        "host": {
            "connection": {
                "name": "@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$connections']['shared_office365_2']['connectionId']"

3. So if you click the three dots in the menu again, you can select your connection. I had 3 connections. 2 for another person and 1 for myself. If you change these connections and peek code again, the connection name will change to 'shared_office365_1' or 'shared_office365_2', etc.

4. In my case none of them showed the connection as 'shared_office365', so I added a new connection. When I did that I ended up with 3 of the other person and 1 for myself. The connection changed for myself, and the second connection of the other person finally showed 'shared_office365', so I saved the flow with that connection and everything worked.

Hope this helps.

Was this reply helpful? Yes No
Eirik1337 36 on at

Like (0)

Report

I have the same problem, connections that don't exists.
How did you add new connection?

I see no where to change it. Flow is too hard coded it's frustrating.

Was this reply helpful? Yes No