cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Blair24
Frequent Visitor

Connecting to SQL via Gateway - Token Error

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


Error.PNG

 

1 ACCEPTED SOLUTION

Accepted Solutions
abm
Super User
Super User

Hi @Blair24 ,

 

This might be useful

 

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

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

3 REPLIES 3
abm
Super User
Super User

Hi @Blair24 ,

 

This might be useful

 

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

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

View solution in original post

Blair24
Frequent Visitor

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?

Hi,

 

Glad that resolved your gateway error.

 

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

 

Thanks



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blog
Power Automate Video Tutorials

Helpful resources

Announcements
User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (2,439)