Uploading a certificate .pfx with path and password using .NET new X509Certificate2(, , X509KeyStorageFlags.EphemeralKeySet);it can work when you try on a local machine, but if you… Read More

I know I'm old and a bit anachronistic but I had to modify an old solution for a customer of mine and I need to create a declarative web feature to deploy workflow custom activities thanks t… Read More

I finally go back to writing a few lines of code.I created an Azure function by using Visual Studio 2019 and .Net Core 3.1.The thing that left me puzzled is that I haven't found a class to h… Read More

SharePoint Rest API expose a method to check permission on a specific securable object (e.g. a list item).https://zsis.sharepoint.com/sites/mysite/_api/web/lists/getByTitle('mylist')/items(9… Read More

Coronavirus disease 2019 (COVID-19) is an infectious disease caused by severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2). The disease was first identified in December 2019 in Wuha… Read More

I need my psychoanalyst.When I try to delete a document library folder with a lot of files and subfolder (SharePoint is a CMS… The probability to have large folders is very high), I g… Read More

There is nothing to say: the modern pages of SharePoint Online are more appealing than the classic ones.In some cases, I need to add a modern page to a classic site in order to allow the use… Read More

Thanks to this very useful post, I resolved this annoying problem:Task Bar Application Search show a black screen.https://superuser.com/questions/1522905/windows-10-search-not-loading-showin… Read More

This post will show a very easy way to export a generic IEnumerable into an Excel file within an Azure Function V2.This is very useful, for example, to give the user the capability to export… Read More

Here a step by step easy tutorial to securely call an Azure Function from SharePoint Framework application. Register an Azure AD appYou can choose to skip this registration and ask to t… Read More

How to get data from a SQL Database with an Azure Function by using Entity Framework in 6 minutes.Be careful to the Nuget Package EF version.Enjoy!!! Read More

Here a simple example of how to terminate a specific instance of a SharePoint Online Workflow by using CSOM object model.Inline all comments...using Microsoft.SharePoint.Client;usingMicrosof… Read More

Another useful Power Query Excel Workbook that allows you to extract all SharePoint Group Members from a SharePoint Online Site Collection.You have only to type the SharePoint Site Url insid… Read More

In this posthttps://zsvipullo.blogspot.com/2016/01/copy-users-from-one-sharepoint-group-to.htmlI explained how easily extract all SharePoint Group Members in order to populate a new group.Ye… Read More

On a flat view in a list or library there isn’t a breadcrumb to navigate through folders, even if it would be really useful to have the possibility to navigate to a parent folder.A pos… Read More

My goal in this case is very simple: read messages inside the shared mailbox outbox folder from an Outlook Add-In in order to perform some operation on them.My code is very simple:private vo… Read More

We are writing a simple Outlook Add-In which must perform some actions only when the client PC is connected to internet.Here a simple code snippet to check if you computer is connected or no… Read More

And now, ready away, a question: where office store custom Add-In configuration while a VSTO has been deployed?An easy way to add configuration to your own Office Add-In, for example an Outl… Read More

When you try to extract all the attachments from an email with Microsoft Flow, you get even signature images.I've needed to save all attachments to a SharePoint library and I didn't want to… Read More

SharePoint doesn't provides an OOB way to navigate through a folders structure of a List View Web Parts in classic pages, but it whould be really usefull for end users that are familiar with… Read More

I need to avoid the delation of an item from a SharePoint list without change the permission of users, because I want they will still be able to delete items with custom buttons that hide ot… Read More

Within my .Net console application, I used Microsoft Application Insights in order to log traces and exception by using NLog Nuget Package.Here a link to GitHub that talk about this argument… Read More

Talking about SharePoint REST API cache.I created an Azure Web Job which, by using SharePoint REST API, checks if permissions inside items of an application of our have or not anomalies. If… Read More

Another strange SharePoint behavior which made me suffer not a little.The scenario is very simple: I’ve a custom list with a few columns:TitleCustomer NameOrder NumberOrder DateOrder D… Read More

Here a simple M Language Custom Function used to convert UTC datetime field to local time.In my case I get from SQL server databasetime field containing the UTC start date of an operation.I… Read More

Azure File Sync is a nice Microsoft service which allows you to synchronize the content of several on premises servers with a Azure File cloud repository.https://azure.microsoft.com/en-us/ro… Read More

Power Query is a very powerful Excel Add-in which allows you to download data from a lot of different sources and then perform in memory data elaboration on them.When standard features are n… Read More

In this post of my bloghttp://zsvipullo.blogspot.it/2018/05/create-simple-excel-power-query-user.htmlI described how create a simple Power Query User Function.Now I try to show an example of… Read More

One of the most interesting feature of the Azure Jeb Job is the capability to schedule a recurrent task, for example every day at 6 am.I will not elaborate on how to create an Azure Web Job… Read More

A little post to describe how I can create a SharePoint Search Result Search in order to display document based on a specific parent content type only.A bracket on how SharePoint content typ… Read More

Following this great examplehttps://blogs.msmvps.com/windsor/2017/03/12/walkthrough-building-a-custom-web-api-for-use-with-sharepoint-online/and thanks to my Tenant Administrator AleBella, I… Read More

One of the SharePoint most powerful feature is the capability to set a custom security with a granularity up to each single Securable Object: site, list, folder, document or also a single li… Read More

Here a simple example of how I can upload very large file from my local file system to an Azure Blob Storage.I collected few chunks of code found on the network and I create a console applic… Read More

Another great day!I’ve some Azure App Service and Azure Web Job which, using SharePoint CSOM or calling the SharePoint REST API, perform a lot of operation (batch or real-time) on Shar… Read More

Take for example the following situation: I’ve in my Power Query Model a Student Table and another table with the student’s votes with a One to Many relationships.Now I want to a… Read More

A client of mine asked me to extract Active Directory data (for example using ADSI Edit), filtering them for a datetime field, for example accountExpire.Googling I found a string like this:(… Read More

Premise: I’m not a web developer and I have little familiarity with all these new names that emerge as mushrooms from one moment to the next.Then I share with you my experience without… Read More

In this post I’ll explain how I can add a custom property to a JPEG Image.Why this? In my case I’ve to associate to the picture some metadata about a specific item of a productio… Read More

Often, I need to export Excel table into a JSON file.While if I have to save XML file, Excel helps me saving the table in this format, I can’t find anything that allow me to get JSON r… Read More

Before Microsoft Delve came to our life, when I clicked on SharePoint Group Member Hyperlink, I was able to access to a very nice page which show the user information.Now, by navigating the… Read More

Welcome back from holidays, or, at least for me…My holidays, my too short holidays😊Talking about SharePoint REST API call and multiple $Expand operations.In my case I want to… Read More

This article is a free translation of an old post of mine written 3 years ago but always alive: what kind of permission I must have in order to start a SharePoint Workflow?Here the link to o… Read More

Here an example of how I can use Microsoft Cognitive Service to convert speech to text.Between the code lines you can find some helpful comments.using Microsoft.CognitiveServices.SpeechRecog… Read More

I’m not a video maker and I’m not able to use complex and not free video editor but, above all, I don’t want to spend my money to buy an expensive video tool and to spend m… Read More

Within a SharePoint Online customization deployed using PnP, I got an error navigating the Document Set settings page from the Content Type Settings page.No error details was shown from the… Read More

In the last years, I worked as consultant for a multinational company and I design several SharePoint Online applications, adding to the OOB product functionality a lot of customizations tha… Read More

Friday evening, my wife asked to me an easy way to merge some pdf documents into a single pdf file.I suggested her to use one of the millions of sites which allow you to perform this operati… Read More

Excel Power Query is a great tool which allow my users to download SharePoint Online data into Excel tables and then perform self service business intelligence using Pivot Table, Chart and o… Read More

One of the developer salient themes is the NULL management.When you get a Null Reference Exception https://msdn.microsoft.com/en-us/library/system.nullreferenceexception(v=vs.110).aspxor an… Read More

Another simple post that describe how to upload metadata of an existing SharePoint Online document using REST Api from a C# (.Net) application.You need to add the following NuGet packages an… Read More

It may be a useless post but I can’t find a complete example of how upload a document inside a SharePoint Online document library using REST Api from a C# (.Net) application.All you ne… Read More

Recently a friend of mine asked to me where he can store some data coming from several devices and usable from everywhere.My first think is to create a REST service which write data into an… Read More

I’ve a SharePoint Online customization used by a lot of people which use SharePoint 2013 Workflow to approve or reject business data entity. Approval workflows have a lot of approval s… Read More

Be careful to the case of your SharePoint Site Collection!As explained in a post of minehttp://zsvipullo.blogspot.it/2015/04/invoke-sharepoint-rest-api-using.htmlis possible to invoke ShareP… Read More

Without words...using Microsoft.SharePoint.Client;using Newtonsoft.Json;using System;using System.Net.Http;using System.Security;using System.Threading.Tasks;namespace GetFormDigest{ &n&hell…Read More

Here an example of how retrieve SharePoint list data using Rest API and pagination. It is a particularly useful when the list has a number of record greater than the SharePoint threshold lim… Read More

Working with SharePoint REST call, I often have to deserialize JSON string with strange property name, for example odata.nextLink, with a nice DOT (.) inside.Here an example...{"odata.nextLi… Read More

Today I’m talking about Scheduled Azure Web Job.Azure Web Job is a very nice way to run your code inside a cloud based environment. Azure WebJobs provide an easy way to run scripts or… Read More

Welcome to a new infra post… Yes, I’m not a system engineer and neither I wish to be it, but until it comes to press Next, Next, Next, Accept, End… I’m a very exper… Read More

Finally, the killer app!!!I’ve got a Lenovo S430 laptop, a very nice laptop which works with me for 3 years.This pc has a little problem: it has no a CAPS LOCK indicator. The solution… Read More

Do you need a free OCR? Are you a developer? Make it by yourself!!!Using Microsoft Cognitive Service – Computer Vision, you can easily recognize the text present inside an image and co… Read More

Here a simple example of how to create an “in memory” zip file using c# and .Net Framework.My real need is to send a mail attachment containing a lot of files stored into an Azur… Read More

Another post a little ‘more’ infrastructural, which perhaps can also affect our cousins with screwdriver.Scenario:I’ve a little SharePoint farm composed by the following Hy… Read More

I created a SharePoint ECB Custom Action using the (legacy) declarative paradigm of the SharePoint solution, creating a no code sandboxed solution deployed into Office 365 SharePoint site co… Read More

I take six years to discover this new great Microsoft .Net feature introduced with the 4.0 version (in the far 2011).Use the Dollar ($) syntax!!!For a lot of years, I uses the string.Format… Read More

Using Microsoft Outlook, we can easily create a Skype Meeting and invite people outside your organization to join this meeting.https://support.office.com/en-us/article/Set-up-a-Skype-for-Bus… Read More

I created an Excel Workbook which, using Power Query, downloads from a SharePoint Online data source the content of a document library.This workbook has been distributed to a lot of users pl… Read More

I pretend that Microsoft pay me the psychologist.Another incredible behavior of our preferred product!!!Talking about large lists.All know that since the 2010 version, Microsoft introduced t… Read More

This post translates and share an interesting observation of a colleague of mine, companion Matta, integrated with some comments by myself. In italic my comments, in normal text the org… Read More

Here a simple post where I'll show how to get the list of all SharePoint role definitions and all metadata, among wich the Role Definitions Id, that can be used to assign permission using RE… Read More

This post shows how we can configure external provider to integrate authentication within a custom Web Application. Its scope is to guide the developer to the right configuration of the prov… Read More

Today I tried to use authentication within an empty Visual Studio ASP Net Web Application, using external provider like Google, Facebook, Twitter, Microsoft…My Web Application consist… Read More

SharePoint 2013 expose OOB REST Api that help the developer to perform client side operation within SharePoint data.https://msdn.microsoft.com/en-us/library/office/jj860569.aspxIn this post… Read More

This post describes how to remove easily the VBA Project protection inside an XLSB Excel Workbook....even if it is against my nice-guy ethics…For first you must create a backup copy o… Read More

Here a short video (in italian language) on which I'll show a simple example of how to use Microsoft Face Verification Service.Sorry for my voice but it's just my voice:)Mom gave it to meIf… Read More

Three years ago, I wrote a post taking about PDF conversion using SharePoint Word Automation Services.http://zsvipullo.blogspot.it/2013/07/create-pdf-with-sharepoint-pdf-helper.htmlThis was… Read More

IntroductionTaking at full hands from Microsoft Official Samples, I created a very simple WPF application that, using the Microsoft Cognitive Service, is able to identify one or more face on… Read More

Another nice little joke of mum Microsoft talking about Sandboxed Solution within SharePoint Online.Without any notice, yesterday, trying to activate a WSP solution that worked perfectly unt… Read More

Connecting to SharePoint Online site collection using Microsft Excel Power Query Addin I got within the client of 3 customers of mine a strange behavior: the authentication form returns the… Read More

Talking about SPUtility.SendEmail method…https://msdn.microsoft.com/en-us/library/ms460489.aspxThis method is used, behind the scenes, by several SharePoint  artifact: Workflow… Read More

I often develop critical windows services which have the need to be always on, even in case of a crash.My idea is to develop a parallel windows service with a very simple business logic whic… Read More

Here a very simple hand made trace viewer created using a console application.Few code lines for the maximum result!!!You can also use it by clicking on Open With context menù.us… Read More