Answered

SQL - Execute a SQL query (V2) - issue

(0) Share

Report

Posted on by frederikbisback

222

Unable to process template language expressions in action 'SQL - Execute a SQL query (V2)' inputs at line '1' and column '2093': '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_azureautomation'. Please see https://aka.ms/logicexpressions for usage details.'.

Can somebody assist me in this issue?

Get this message already for the second time. Removed Flow and imported the flow solved the issue until today.
Is this an issue with the connectors action v2?

Thanks for the feedback.

All responses (6)

Answers (1)

Verified answer

yashag2255 24,523 Super User 2024 Season 1 on at

Like (0)

Report

Re: SQL - Execute a SQL query (V2) - issue

Hey @frederikbisback

Is your Flow being triggered from a PowerApp?

In that case, after registering the flow on a control in PowerApps, if at all you add any action or make any modification in the Flow, you will see that error (the one you mentioned in the post originally) and in such a situation the only remedy as of now is to unregister your flow from the control in PowerApps and then re-add it on that control there. (Makes sense?) This has worked like a charm all the time I faced such an issue.

Hope this Helps!

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!
frederikbisback 222 on at

Like (0)

Report

Re: SQL - Execute a SQL query (V2) - issue

This could be an explanation:
https://support.microsoft.com/en-us/help/4477072/best-practices-updating-a-flow-used-by-a-powerapp
frederikbisback 222 on at

Like (0)

Report

Re: SQL - Execute a SQL query (V2) - issue

Having a problem with several flows, where I use this action. Having changed the action connector for each SQL query, to the newly defined SQL connector (SQL user). Seems to be braking something in the background. Could this cause an issue?
frederikbisback 222 on at

Like (0)

Report

Re: SQL - Execute a SQL query (V2) - issue

Export / import the Flow solved the ERROR.
But what is causing this issue?
Thanks for the quick feedback.
frederikbisback 222 on at

Like (0)

Report

Re: SQL - Execute a SQL query (V2) - issue

@v-alzhan-msft, Today did again a test. Same issue.
Unable to process template language expressions in action '[action name]' inputs at line '1' and column '2093': '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_azureautomation'. Please see https://aka.ms/logicexpressions for usage details.'.

Thanks for the quick feedback.

Regards,

Frederik
v-alzhan-msft on at

Like (0)

Report

Re: SQL - Execute a SQL query (V2) - issue

Hi @frederikbisback ,

I'm afraid that it is an accidental error and now it is fixed.

Best regards,

Alice

Community Support Team _ Alice Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.