Power Platform Community Forum Thread Details

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

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)