SharePoint Online – App Only Calls returning “System.Net.WebException: The remote server returned an error: (401) Unauthorized”

Recently I had an issue with a SharePoint Remote Event Receiver that was returning a 404 error. I had given correct permission in the appmanifest.xml. The clientcontext was being created with the following code: After digging around I discovered that newer SharePoint Online sites have app only permissions disabled. To enable it I ran the […]

Getting all events in a Calendar using Microsoft Graph and C#

I couldn’t find any examples online on how to get all events in a calendar programmatically using Microsoft Graph and C#. The only example I could find would return 10 items, being the page limit. In order to save others time, I decided to post the way I managed to do it, using Skip. This […]

Assigning task to related task

Assigning task to related task In my youtubo video, I demoed how you can create a Ticking and Tasking System using just SharePoint and PowerAutomate. You can view it here I was asked how you could prevent a ticket being created if it was related to an already open ticket (Ie a reply or […]

Searching the SharePoint Recycling Bin

Searching the SharePoint Recycling Bin While the SharePoint recycling bin is useful when it contains only a few items, it becomes downright unusable when it contains thousands of items. The SharePoint recycling bin is shipped without a search function. Finding a single file in a SharePoint recycling bin of thousand of items is like searching […]

Checking if string is empty or null in MS Flow / Power automate

Below is a simple way to check if a string is null or empty in MS flow. It works by first testing if the string is null, and then checking if the string has 0 characters. Steps: Add a condition step Change the condition to OR Add the string variable, and first test to see […]

Updating Filename in MS Flow (Power automate)

Updating Filename in MS Flow (Power automate) This is a walk through on how to update a filename while keeping the same file extension in MS Flow. In this example we are going to assume the filename is saved in a Variable called “Full File Name”. The walkthrough will name a file to <filename>_1.<extension> We […]

SharePoint Online Vs SharePoint On-Premises

SharePoint Online Vs SharePoint On-Premises  SharePoint online is a multitenant offering by Microsoft designed to meet the needs of most companies document management requirements. Technical documentation references huge capacity capabilities well beyond the scope of most SharePoint sites however real-world practical use does expose additional limitations.   Performance  The most prominent disadvantage of SharePoint online is form load times, […]

Mail Redirection & Scanning

The Team at SharePointPro are proud to support Gold Coast Local Business HotSnail.

Adding “Days since created” on a SharePoint column using JSON Custom Formatter

I wanted to add a column on a SharePoint modern experience list which showed the number of days since it was created. I also wanted to colour the dates so that if it was over a certain number of days it would display as yellow or red. I found very little examples online, so I […]

Problem: SharePoint Online Document & Onedrive takes time to sync.

A client recently informed me that after a docx was generated inside their SharePoint Online Document library, it wasn’t showing up on for up to 20 minutes in OneDrive. This was a problem for them as the docx was generated via custom code inside of SharePoint and they needed to work on it straight away. […]

Force AD Connect Sync with Powershell

AD Connect syncs occur every 30 minutes. To force a sync to occur do the following steps: On the AD Server in Active Directory Module for Windows import the required module: Import-Module ADSync Run the delta sync with the command: Start-ADSyncSyncCycle -PolicyType Delta

Permanently Removing Users From O365

After deleting a user from Office365 you will notice they remain in the “Deleted Users” list. This can be problematical when trying to sync a user with AD Connect. To remove permanently you will need to do the following steps in powershell: 1. Connect to your Office 365 in SharePoint Online Management Shell: Connect-MsolService 2. […]

Creating SharePoint Online Remote Event Receiver

Creating a remote event receiver for a SharePoint Online site can be a frustrating experience. When it does not work there is very little diagnostic information to look at to figure out why its not firing. I’m going to go over a brief check list that will hopefully prevent others spending hours on what should […]

Sharing Communication Site With External Users

After creating a SharePoint Communication site I wanted to share it with an external user. When attempting to share the site I got the error Your organization’s policies don’t allow you to share with these users. Go to External Sharing in the Office 365 admin center to enable it. But I had sharing enabled via […]

SharePointPro supports the push to make the Gold Coast the next Silicon Valley

Silicon Valley has truly made an undeniable mark on the world. San Francisco’s hub of technology, invention, and startups has seen the likes of Apple, Google, Uber, and Airbnb all based within its hills. The American centre for innovation has had a huge impact on the global economy, with “disruptors” (i.e. inventors) constantly looking to […]

New SharePoint 2016 Features: Microsoft Flow App, PowerApps, and Updated Framework

Microsoft clearly prioritized development in its release of SharePoint 2016, and the effects are obvious. Both front and back-end developers have seen much TLC from Microsoft, as they continue to encourage enhanced customization along with basic user customization. So, how can you use this new version of SharePoint to complement and boost your business? Here […]

SharePoint bulk DELETE function

I had the requirement to delete multiple list items for a clients SharePoint 2013 site. I wanted to stick with using REST as opposed to the CSOM as my custom built framework makes use of it primarily. The way to accomplish this is to take advantage of ODATA’s batching. Rather than go to much into […]

What’s new with SharePoint 2016

Alas, we know what it’s like. Trying to ensure that a team works smoothly is easier said than done. Remote collaboration is essential in the modern technologically-shrunk world, and we all need solutions for integration and collaborative teamwork. This is where SharePoint comes in! SharePoint (for those who may not know) is a server-based platform […]

Software Is Expensive

Everyone likes to get a bargain, but there are many things in life where you get what you pay for. When it comes to the code required to write your customized website, integrated proprietary software, or advanced web or mobile app—paying less might sound attractive, but in most cases leaves you paying more. Code Is […]

Upsert function for Rest SharePoint API

Here is a simple wrapper function I created for use with the SharePoint Rest API. If an Id is entered the function will update a record, otherwise it will insert a new record. Usage: [SyntaxHLNumbers] //Create ListItem Object var customers = {}; //Set List Name customers._listName = “Customers”; //Add columns to insert customers.Name = “Michael […]

Replacing SharePoint DatePicker

If you have ever used SharePoint, you probably know that SharePoint’s native datepicker’s is horrible. Clicking the native datepicker will cause the entire page to post back, if the page is scrollable, this will take the user to the top of the page. A simple solution is to remove the datepicker image link, and replace […]

SharePointPro Entity Framework

SharePointPro Entity Framework SharePointPro is proud to announce that we will be releasing our customised SharePoint Entity Framework to the Open Source Community. SharePointPro entity Framework is a SharePoint First Entity Framework to simplify access to SharePoint Online or On Premises. The Framework can automatically generate SharePoint lists as Entities and create a context with […]

Multiple domain cookie in ASP.NET Core Identity

I have a webpage which uses multiple URLS for the same application: for example: * * So I needed the cookie to be saved less the subdomain to allow authentication across all parts of my webpage. An important thing to realize is the difference between Identity and CookeieAuthentication. Alot of blogs on the internet will […]

Provider Hosted App Times Out

Disclaimer: The supplied solution is convoluted, a better solution would be to completely recreate the SharePointContext class. I came across a problem with a SharePoint Provider Hosted App I created for a client while working on the Gold Coast. The app was a Single Page Application created in MVC C# utilising the standard SharePointContext and […]

Web deployment task failed.

​After setting up and using Web Deployment from Visual Studio 2013 many many times, I experienced an error: Error 79 Web deployment task failed. (Web Deploy experienced a connection problem with the server and had to terminate the connection. Contact your server administrator if the problem persists. Learn more at: I couldn’t figure out […]