Answered

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...?

Categories:

Using connectors

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

abm abm 32,865 Most Valuable Professional on at

Like (1)

Report

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

Was this reply helpful? Yes No
Blair24 25 on at

Like (0)

Report

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?

Was this reply helpful? Yes No
abm abm 32,865 Most Valuable Professional on at

Like (0)

Report

Hi,

Glad that resolved your gateway error.

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

Thanks

Was this reply helpful? Yes No