Hello,
I am running SharePoint Online developer site as my tenant and using Visual Studio 2019 as a development environment.
I am learning SharePoint development and reached till the page "Include an add-in part in the provider-hosted add-in".

I am stuck with the error of having spContext was null. It seems that I get this error almost everywhere. However I tried to overcome this error by adding the code
if spContext == null { spContext = SharePointContextProvider.Current.GetSharePointContext(Context); } else { spContext = Session["SPContext"] as SharePointContext; }

But at this stage I am not able to pass this error, kindly help.

Thank you and
Regards

The error message says the DB does not exist and that is why it is breaking

Getting an "Access denied. You do not have permission to perform this action or access this resource" when launching the FinalChainStoreAdd-in solution. Error seems to be originating from Line 119 in SharePointComponentDeployer.cs

Exception Details: Microsoft.SharePoint.Client.ServerUnauthorizedAccessException: Access denied. You do not have permission to perform this action or access this resource.

Source Error: 


Line 117:                webScopedEmployeeAction.DeleteObject();
Line 118:
Line 119:                clientContext.ExecuteQuery();
Line 120:            }
Line 121:        }

Source File: C:\DevSamples\SharePoint_Provider-hosted_Add-ins_Tutorials\9_FinalChainStoreAdd-in\ChainStoreWeb\Utilities\SharePointComponentDeployer.cs    Line: 119 

With the release of SQL Server 2016, the SSDT db instance is "(localdb)\ProjectsV13". However, connectionString in the web.config file of the ChainStoreWeb project points towards "(localdb)\ProjectsV12". Therefore if the latest SQL Server release is installed, an exception of type 'System.Data.SqlClient.SqlException' occurs when establishing a connection to SQL Server.

Therefore, in my opinion, so that this project functions 'out-of-the-box' using the current articles, the connectionStrings should be updated to V13

@Rick-Kirkham if you agree with this suggestion, I don't mind updating the queryString in each solution. I would like to save future users the bit of debugging that I did.

I downloaded to my server,
Windows 2012 R2

"The required version of SharePoint Foundation or SharePoint Server is not installed on this system. The target version of the SharePoint project is 16.1. ChainStore 0

Win 2012 R2, VS 2017.
I have local on-premise SharePoint 2013 with MSSQL 2008 R2 (this on-prem is stopped, I use SharePoint Online url in Project Settings.)

Did You use VS2017 with no additional developer tools?

I notice a Response.Redirect in the solution as an example to a list in the host tenant using:
// Go back to the Local Employees page
Response.Redirect(spContext.SPHostUrl.ToString() + "Lists/Local%20Employees/AllItems.aspx", true);

I desire to navigate from the OrderForm.aspx page to CorporateDataViewer.aspx page while in Debug mode on my local. Desired placement for the redirect is at the end of the btnCreateOrder_Click method right after the CreateOrder(txtBoxSupplier.Text, txtBoxItemName.Text, quantity); call verses clicking "BACK" browser button twice as stated in the tutorial instructions.

I used Response.Redirect("CorporateDataViewer.aspx", false); and received the error notice "An error occurred while processing your request." from the CorporateDataViewer Page_PreInit.

I think the context has been lost at the OrderForm.aspx page so I read that the redirect needs some assistance from the TokenHelper.

Response.Redirect(TokenHelper.GetAppContextTokenRequestUrl(spContext.SPAppWebUrl.ToString(), Server.UrlEncode("Page/CorporateDataViewer.aspx")));

When I try the redirect above the SPAppWebUrl is null form the SharePointContext.cs using:

// SPAppWebUrl
string spAppWebUrlString = TokenHelper.EnsureTrailingSlash(httpRequest.QueryString[SharePointContext.SPAppWebUrlKey]);
Uri spAppWebUrl;
if (!Uri.TryCreate(spAppWebUrlString, UriKind.Absolute, out spAppWebUrl) ||
!(spAppWebUrl.Scheme == Uri.UriSchemeHttp || spAppWebUrl.Scheme == Uri.UriSchemeHttps))
{
spAppWebUrl = null;
}

How do I get the SPAppWebUrl? Is this the direction to pursue for the redirect to CorporateDataViewer.aspx page?

Please help, thank you!

Hi,

I am currently testing your tutorial/guideline on my on-premise SP 2013 Enterpise Server (with CU January 2016).
It seems that my Ribbon/Chrome control is somehow bugged.
I tested it in different browsers from IE, Edge to FireFox.

As you see in the image above the icon of the question mark is not displayed correctly. Furthermore I don't have a background change and right border when I hover/click the icon. That's a diffrent behaviour compared to the 'official' ribbon.

Last but not least I can't close the dropdown window when I click on an empty page area.
I don't get any script errors...

Is this a bug or normal? Can anyone guide me in a direction for a fix. I can't debug that minified SP.UI.Controls.js.

thaxy

VS2017 15.8.3.
Win10.

I am getting below error while debugging solution 1_BeforeSharePointUI

Severity Code Description Project File Line Suppression State
Error This project references NuGet package(s) that are missing on this computer. Use NuGet Package Restore to download them. For more information, see http://go.microsoft.com/fwlink/?LinkID=322105. The missing file is ..\packages\Microsoft.CodeDom.Providers.DotNetCompilerPlatform.1.0.0\build\Microsoft.CodeDom.Providers.DotNetCompilerPlatform.props. ChainStoreWeb C:\Users\Administrator\Desktop\SharePoint_Provider-hosted_Add-ins_Tutorials-master\SharePoint_Provider-hosted_Add-ins_Tutorials-master\1_BeforeSharePointUI\ChainStoreWeb\ChainStoreWeb.csproj 229

can anyone help me with this.