cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Blair24
Level: Powered On

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
Super User
Super User

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

 

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!



View solution in original post

3 REPLIES 3
Super User
Super User

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

 

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!



View solution in original post

Blair24
Level: Powered On

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?

Super User
Super User

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



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!



Helpful resources

Announcements
firstImage

Incoming: New and improved badges!

Look out for new contribution recognition badges coming SOON!

firstImage

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

firstImage

New & Improved Power Automate Community Cookbook

We've updated and improved the layout and uploading format of the Power Automate Cookbook!

thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

sixthImage

Power Platform World Tour

Find out where you can attend!

seventhimage

Webinars & Video Gallery

Watch & learn from the Power Automate Community Video Gallery!

Top Kudoed Authors
Users online (6,136)