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

(0) Share

Report

Posted on by marcgiag

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)

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

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

a-ovbord on at

Like (0)

Report

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

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

Was this reply helpful? Yes No