This post is about how to crate a list item in SharePoint list in backend process. It can be API, background service, azure function, mobile or desktop app. So, it can be anything you want, but in .Net. And we will use SharePoint Rest API, that is wrapped by CSOM (Microsoft.SharePointOnline.CSOM).

To update the Created Field for SharePoint list item you can start the script like this. The most important here is the 'fullcontrol' permissions and '-UpdateType UpdateOverwriteVersion' parameter in the request.

For a process I had to update the Author field in SharePoint online list item. This time I decided to use PnP.Core instead of PnP.Framework. Was it worth it? I don't really know, but the method is not the most difficult part of the task.

There's a small snippet to check if current user permissions are enough to save list items. It can be used in SPFX webparts with PNP JS.

There are a lot of cases when you need to get the items by the author. For me the only correct way to get the SharePoint list items by user with CAML is like this:

<Where><Eq><FieldRef Name='Author' LookupId='TRUE' /><Value Type='Integer'>123</Value></Eq></Where>

You can delete timer job only with PowerShell. Why? I guess you know why 🙂 The most popular reason is the duplicating of timer jobs. To delete a timer job, you need to know the ID. And you can get it also with PowerShell or with GUI.

Below you can find a PowerShell script to copy items from one SharePoint list at one site to another SharePoint list in another site. I use it with several modifications to work with the data in test environments.

I had a SharePoint online list and I added a new column into it. And then I wanted to work with a data, which is close to be real. So I needed to generate the data and insert it into the list. For the tasks like this I like to use division by module to create semi-random data.

While writing the script to create lists for my solution for SharePoint Online I had to rename Title field in a list. It's not so obviously as just to create a new field.

I used EventCalendar component with resources and timeline view, the default interval is 1 month, I also add week numbers to the header. I wanted to fit the calendar to the page without horizontal scroll.