Unanswered

Connecting to SQL via Gateway - Token Error

(0) Share

Report

Posted on by Blair24

Hey Folks,

Getting the following error when trying to connect to an on prem SQL connection via the gateway.
The gateway is up and running, Power BI and other PowerApps/FLows are connecting to it fine but when I try to create this new flow I get the following error - not something I've came across before...?

All responses (3)

Answers (1)

Verified answer

abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: Connecting to SQL via Gateway - Token Error

Hi @Blair24 ,

This might be useful

https://powerusers.microsoft.com/t5/General-Flow-Discussion/Problems-when-trying-to-Mark-an-email-as-read/td-p/117506

Thanks
abm abm 32,464 Most Valuable Professional on at

Like (0)

Report

Re: Connecting to SQL via Gateway - Token Error

Hi,

Glad that resolved your gateway error.

Could you post a screen grab of your flow and error?

Thanks
Blair24 25 on at

Like (0)

Report

Re: Connecting to SQL via Gateway - Token Error

Hey @abm,

That seems to work - thanks!
Got a second error now, I know Flow & PowerApps requires SQL to have a primray key - which this table has, but Flow is stating that it doesn't, have you came across this before?