web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Apps / On-Premise Gateway wor...
Power Apps
Answered

On-Premise Gateway works when creating an app but not when published

(0) ShareShare
ReportReport
Posted on by 92

I have already tried to disable Explicit Column selection in advance settings to correct the below issue:

 

Hello Community,

 

I have created an application that has both SharePoint and SQL Server (through an on-premise gateway)

 

My application is designed to create and manage records on SharePoint. There is nothing wrong with this piece of the functionality.

 

When I am editing the application in Design mode(unpublished) I am able to access my SQL to do a lookup and pre-fill information on my form this works amazingly...

2020-02-28_12-50-29.jpg

 

Using the same computer, login and web browser...

Once I publish this the lookup function using my SQL connection no longer works on the published version.  I found a suggestion to disable  Explicit Column selection and that didn't seem to work see below (same lookup) 

2020-02-28_12-53-14.jpg

 

ANYTHING you can go to assist would be amazing....I'm proud of this one lol 

I have the same question (0)
  • Verified answer
    a-ovbord Profile Picture
    Microsoft Employee on at

    Hi @marcgiag,

     

    Please try the following actions:

    - try this in a different browser and also in incognito

    - logout from the session, clear cache and retry

    - check if you have any experimental features enabled and disable them

    - do you still have a valid subscription?

     

    Thank you,

    Ovidiu

     

     

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Users!

Kudos to our 2025 Community Spotlight Honorees

Congratulations to our 2025 community superstars!

Leaderboard > Power Apps

#1
WarrenBelz Profile Picture

WarrenBelz 529 Most Valuable Professional

#2
Haque Profile Picture

Haque 230

#3
Kalathiya Profile Picture

Kalathiya 217 Super User 2026 Season 1

Last 30 days Overall leaderboard