Power Platform Community Forum Thread Details

A similar issue has occurred previously, where the error suggested creating a new connector for excel. I deleted the old connector, and started the tedious work of updating all actions in all flows flows to use the new connector. But I noticed that it was two different versions of the same connector, only way to make it work again was to create the connector that i deleted using the other version because using the new connector produced the template error. Back then the two different connectors had different icons (both were the "business" kind, the difference was not simply the OneDrive-version), trying to create a new connector now only reveals the one.

Then I had to go through the process of checking all flows again anyway because deleting it in the first place disassociated them. Then i had to test everything or check the code (peek code) because they look identical in the editor UI.
The difference seen in the action for excel: ("shared_excelonlinebusiness_1" vs "shared_excelonlinebusiness")

//Connector 1 selected:
"connection": {
 "name": "@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$connections']['shared_excelonlinebusiness']['connectionId']"
}
//Connector 2 selected:
"connection": {
 "name": "@json(decodeBase64(triggerOutputs().headers['X-MS-APIM-Tokens']))['$connections']['shared_excelonlinebusiness_1']['connectionId']"
}

Now I have problems again, errors tell me that my connector either does not exists or there is a "InvalidTemplate" when trying each of them.

The connection list displays both connections as "Connected":

I'm thinking that i could perhaps change the connector and then save it to revert it back to fix it. but alas, this only causes all the input to the action to be lost and this is a major issue at the moment:

excel business "add row" action
Edit: to clarify, the action causing this is "add row".

I have tried creating 2 identical actions that use each of the two. both fail:
Invalid template error:

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

Not Found error:

{
 "status": 404,
 "source": "https://power-te-northeurope-1.azurewebsites.net:443/tokens/europe-001/excelonlinebusiness/shared-excelonlinebu-XXXXX-XXXX-XXXXX-XXXXXX-XXXXX/exchange",
 "message": "Error from token exchange: The connection (europe-001/excelonlinebusiness/shared-excelonlinebu-XXXXX-XXXX-XXXXX-XXXXXX-XXXXX) is not found. Please create new connection and change your application to use the new connection."
}

The "NotFound" error suggest creating another connection, but that has been done before and just created huge time-consuming mess I do not want, or have time, to do at this point. And if I do this work again, there does not seem to be any guarantee that it won't happen again. But whats worse is that it seems its not possible to choose the correct connector without loosing everything! Please help me, any suggestions would be greatly appreciated!

Categories:

Building flows