Skip to main content

Azure Functions with SharePoint Online

Common trend we came and interesting figure we came up is moving towards Severless where we are not worry about infrastructure. "Azure Functions" is a compute offering which you allow to write custom logic with choice of C#, F# and JavaScript (as for May, 2017).

From the choices above I have chosen SharePoint CSOM (Client Side Object Model) to this sample but if you prefer JSOM or REST API with the requirement, you could go with those.

Lets checkout Azure Functions with SharePoint Online where both in same cloud group which call as SaaS (Software as a Service).

🛠 Step ♳ - Create an Azure Function



You could arrive there with simply following below reference which is common thing and described in every reference.

https://docs.microsoft.com/en-us/azure/azure-functions/functions-create-function-app-portal

🛠 Step ♴ - Adding SharePoint CSOM DLLs



To add SharePoint DLLs to Functions App environment, you required to arrive with Kudu environment.

 Function à Platform Features à Advanced Tools (Kudu)



Shortcut – You could arrive there with URL

https://<function name>.scm.azurewebsites.net/



After you arrived with Kudu portal, check for debug then PowerShell (Command prompt is also available but prefer PS). Navigate to bin folder which resides under following location under you function name and upload your SharePoint DLLs to the folder (i.e. Microsoft.SharePoint.Client.dll and Microsoft.SharePoint.Client.Runtime.dll)

☕ Learn more on Kudu - https://github.com/projectkudu/kudu

🛠 Step ♵ - Refer SharePoint references on the Function



After adding DLLs to the bin, you could arrive with function and start writing you logic within the run.csx.


You could refer added DLLs in the function as below in the top.

#r "Microsoft.SharePoint.Client.Runtime.dll"


#r "Microsoft.SharePoint.Client.dll"


🛠 Step ♶ - Imports references



This is typical step we are doing in any C# which is adding references.

using System;


using System.Security;


using System.Configuration;


using Microsoft.SharePoint.Client;


🛠 Step ♷ - Configuration Values in Azure Function



You will be required the user name, password, and site URL to your SharePoint, those could be done with the application settings as we were keep doing with the web.config files.

Navigate thorough below path and add your configurations where you will be references in function logic.

Click on Function à Platform Features à Application Settings à App settings à Add values as key/ value pairs



Above could be accessed as below in the code.

string userName = ConfigurationManager.AppSettings["User"];



🛠 Step ♸ - Application Logic



You could write as your preference. In my sample on the gist which I have posted below is considered copying list items from one list to another. It's really simple and you could able to expand the logic as you have done earlier with SharePoint CSOM.

https://gist.github.com/kushanlahiruperera/7dfde9a51f955b92c4033aa446bd5867

⌛ Motivations



You could use Azure Functions as Timer Jobs (which we had in SharePoint Server) with scheduling and web hooks and etc.

References - Azure Function Developer Guide

Comments

Popular posts from this blog

Turn off/ Hide Details panel/ Information Panel on modern SharePoint lists

Not always we require to show changes done by other which is a mandatory feature in SharePoint online. 
















What is details pane (aka. Information Pane)? Detail pane/ Information shows information regarding the document if you selected a one or its showing recent changes within a list or library.

Follow linkto Microsoft documentation about details pane.

Bad news: Until Microsoft listen to User Voice, there is no straightforward way to enable disable this even you don't want.
Good news: We could write a SharePoint framework extension to hack styles until Microsoft give us a permanent solution.

How? I found this sample project (Inject CSS into modern SharePoint pages with React) which could reuse to our purpose. Thanks to Hugo for saving my time.  Steps to awesomeness: Clone the projectResolve dependencies > npm iBundle > gulp bundle --shipPackage > gulp package-solution --shipUpload package into SharePoint App catalog and deploy. You could find package under SharePoint folder.A…

File attach (POST) to SharePoint 2013 List (custom) using Angular JS via REST API

Following describes how to upload attachment to SharePoint 2013 custom list using Angular JS.

Note: You can be consumed the JSOM libraries to achieve this, but there is limitation of 1.5 Mb. Better approach would be consuming exposed REST API (SharePoint OOTB) which allowed up to 2 Gb of file to attached using client side scripts i.e. Angular JS. .





Here I have used the “Angular File Upload” which capable of doing more tasks other than basic HTML input file control. By consuming this we can attach multiple files either to the list and etc. You can be found the information on how to include this module to your Angular view in following link.

Use package manager command to install the scripts.
For bower  -->        bower install angular-file-upload

For nugget -->       npm install angular-file-upload
It requires file buffer array to POST (save) our attachment via REST API, browsers FileReader API is required to use. Its available with almost all common browsers. You need to ensure that i…

📢 Update -Microsoft Teams IP Phones and Intune Enrollment

For customers who require desk phones and conference room phones to make and receive audio calls or join meetings, Microsoft Teams provides a growing portfolio of devices that can be purchased from our Teams Marketplace. For Teams phones including the Yealink T56A/T58A/CP960 and the Crestron Flex series IP phones that run on Android 5.x or later, there may be specific configurations that need to be enabled in the customer's tenant for the phones to successfully enroll into Intune. Allowing successful Intune enrollment for Android versions 5.x and upIf all the following conditions below are true, you will need to enable a specific configuration setting in the Intune admin console to allow for a successful enrollment:You are deploying a Teams IP phone with Android OS version 5.x or later.You have connected your Intune tenant with managed Google Play in order to manage Android Enterprise devices.You have configured your enrollment restrictions such that Android work profile enrollmen…