cannot be evaluated because property 'shared_sql_1' doesn't exist

(0) Share

Report

Posted on by drobinson

For the past two days we have had to swtich gateways on our flows to get them to start working again. They all fail with an error similar to this pertaining to 'shared_sql_1'. Not sure what that is? When we point it to another gateway it works for the day. Then fails in the morning and we have to swap gateways again.

InvalidTemplate. Unable to process template language expressions in action 'Update_License_Lines' inputs at line '1' and column '2215': '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'. Please see https://aka.ms/logicexpressions for usage details.'.

All responses (1)

Answers (0)

Doug_Apicella 45 on at

Like (0)

Report

Re: cannot be evaluated because property 'shared_sql_1' doesn't exist

Hey drobinson,

I appears that the reason this is happening is because your token is being refreshed and reverting back to what flow would label the property normally 'shared_sql'.

I found this article maybe it might be of some assistance: https://powerapps.microsoft.com/en-us/blog/custom-api-with-authentication/

If this doesn't help could you provide a bit more detail about your flow with some screenshots of the setup?

Thanks,

Doug
Did I answer your question? Mark my post as a solution!
If you liked my response, please consider giving it a thumbs up