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:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Blair24 25 on at

Like
a
(0)

Report
Copy link

Link copied!

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,998 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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
Verified answer

abm abm 32,998 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

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