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