InvalidTemplate. Unable to process template language expressions in action

(0) Share

Report

Posted on by schuess3

353

I added SQL Action to my Flow to get rows from a Azure SQL Table. When i run the flow i get the follow error. Can you offer some guidance?

Error Message:

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

All responses (1)

Answers (1)

Verified answer

schuess3 353 on at

Like (0)

Report

Re: InvalidTemplate. Unable to process template language expressions in action

I was able to get past this. I was not forming my SELECT statement correctly.