Power Platform Community Forum Thread Details

I'm not sure if my subject makes it clear to understand my issue. I have some 10 flows running. Most of them use the same connection with my Azure DB.

Once in a while I have problems with random Flows. Suddenly the Flow breaks connection with my SQL DB with no reason. I can do nothing to fix but to RECREATE the Flow. It happened two times just today! It's a terrible situation where I can't keep my apps working and have a lot of time wasted redoing my job!

I can't express how much dissappointed I'm with Flow and the whole Poweapps stack. The time I was supposed to save building my app is wasted troubleshooting problems I shouldn't had to.

Error bellow:

Spoiler (Highlight to read)

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

Categories:

Using connectors

Hi @lero,

Do you create multiple connections with different name to your Azure SQL DB?

The error message told that there is something issue with the connections to your SQL Azure DB. The "shared_sql_1" property is not existed in your connections to the Azure SQL DB, the available property is "shared_sql".

I think you have faced Connection-loss errors of Azure SQL DB, more details about connection-loss errors of Azure SQL DB and troubleshooting connection-loss errors, please check the following article:

https://social.technet.microsoft.com/wiki/contents/articles/1541.windows-azure-sql-database-connection-management.aspx

If you create multiple connections with different names to your SQL Azure DB, please consider take a try to remove other connections in your flow and only remain one connection to your Azure SQL DB and check if the issue is solved on your side. In order to remove the connections in flow, please check the following article as a reference:

Manage data connections

More details about troubleshooting connection issues to Azure SQL DataBase, please check the following article:

Troubleshooting issues to Azure SQL DataBase

Best regards,

Kris