Posts

Customizing and Branding SharePoint Master Pages using JavaScript Embedding - Applies to On-prem and Office 365

Image
In this article, I will be sharing a few tips on the customization of SharePoint master page using JavaScript injection. As you might be aware, Microsoft discourages customization of the OOTB master page, and neither do they encourage the use of a custom master page especially for office 365, as doing so will prevent functional updates from being applied to the master page, unless they are manually applied. From maintenance point of view, I think applying updates manually will be cumbersome to maintain especially when you are supporting multiple clients. So I decided to do more research on the best way to have a greater level of control on the master page than just using the alternate css approach. A google search pointed me to the starter template  Core.EmbedJavaScriptJSOM developed by Wictor WilĂ©n. I downloaded it, and started playing around it.  The interesting thing is you can do a lot with JavaScript injection. You can move things around, change color, style the ...

Creating SharePoint Framework Client Web Part and solving the challenges with _RequestDigest Token value using React

Image
Recently I decided to add React and Angular to my portfolio for developing solutions for SharePoint. I'm starting with React and it has been an interesting journey so far. I started with React because Angular 2.x/4.x which is a major leap from Angular 1.x seems to have a few challenges integrating with SharePoint framework as Andrew Connell explains  here . Though these challenges are being addressed with the roll out of Angluar 5 as seen in another of Andrew Connell post:  Solve the SharePoint Framework + Angular Challenge with Angular 5.0 Elements . But as for me, I have decided to wait until Angular 5 is stable for SharePoint framework so that my learning can be seamless.  In this post I will be sharing what I have learnt in my few days of using React in SharePoint framework to build client web part. If you are considering learning React to work with SharePoint framework, these are some of the key concepts you will first need to understand to get started: State...

Performing CRUD operations on Azure SQL Database using SharePoint Framework Web Part and ASP.NET Web API - Part 2

Image
In part 1 of this article we looked at how to set up SQL database in Azure, create a simple get operation in web API and publish the API to Azure. You can read part 1 here: Performing CRUD operations on Azure SQL Database using SharePoint Framework Web Part and ASP.NET Web API - Part 1 In this post we will be further developing our web API to including Post, Update and Delete methods, then call the API within an SPFX web part. Agenda for this post are: Update our Web API to include Post, Update and Delete methods Creating SPFX web part  Consume the Web API and  Implement CRUD operations in Spfx web part Test the web part Updating the API  If you have created a Web API solution as described in part 1, go ahead and copy the code below to update your solution, otherwise go back to part 1 to create a web API solution.  Your final code should look like this: Right-click  on your project and publish to Azure as described in part 1. Creating SPF...

Performing CRUD operations on Azure SQL Database using SharePoint Framework Web Part and ASP.NET Web API - Part 1

Image
When it comes to storing and retrieving large data on SharePoint, my approach (depending on scope though) is usually to store the data in an external database  where I can have full control over the data retrieval and totally avoid dealing with the large list issue due to SharePoint list throttling limit, then render the data on a SharePoint page using visual web part. But like I indicated above, there are a number of things you have to consider before deciding weather you want to store your data on a SharePoint list or directly on an SQL database table.  Important questions to answer are: Will end users be creating views based on different filtering parameter from time to time? if the answer is yes, you might want to consider using a SharePoint list as it already has administrative tools for power users to perform these tasks. This may be a quick win approach for you, particularly where deadline is against you. But you have to bear in mind that your users might have to...