Hero Image
Blog series - Post - Breaking Role Inheritance for a Specific Item in a SharePoint List

Scenario Breaking Role Inheritance for a Specific Item in a SharePoint List Objective: You want to break the role inheritance for a specific item in a SharePoint list, for example when you need to set your own permissions on a file. Steps: Identify the List and Item: You have a SharePoint site with multiple lists, and you need to break the role inheritance for a specific item in a list. I have the list name and item ID stored in variables VarListname and VarItemID , but you’re welcome to use your own names of course.

Thursday, February 20, 2025 | 2 minutes Read
Hero Image
Blog series - Post - Copying a File to a New Location in SharePoint?

Scenario Copying a File to a New Location in SharePoint Objective You want to copy a file from one location to another within a SharePoint site. The source file URL and the destination file URL are known or in variables to use. Steps: Construct the HTTP Request Use the SharePoint REST API to copy the file by specifying the source file URL and the destination file URL in the URL.

Thursday, February 20, 2025 | 1 minute Read
Hero Image
Blog series - Post - Fetching a Specific Item from a SharePoint List by Title and Item ID?

Scenario Fetching a Specific Item from a SharePoint List by Title and Item ID Objective You want to retrieve the details of a specific item from a SharePoint list based on the list title and item ID. Steps: This call is very similar to getting the list item information, but instead of using Get, we use Post, to be able to update our item. In the body, you can then specify what you want to update.

Thursday, February 20, 2025 | 1 minute Read
Hero Image
Blog series - Post - HTTP Update list item term store?

Scenario: You have a metadata column you want to update, but how to do this? Objective: You want to update the status field, with a new status from that term set. Steps Identify the List and Item Like always, I’ll use varsitename in the URL, and in the URI Varlistname and VaritemID. Execute the HTTP Request With this request, I’m updating the name_status field. I will have to have queried the term store before, to get the filter array for the status field I want to have it updated to.

Thursday, February 20, 2025 | 1 minute Read
Hero Image
Blog series - Post - Revoke permissions to a document through the API

Scenario Revoke permissions to a document through the API. Here comes the tricky part. There are 2 kind (that I found) role types on SharePoint. Roles from the Roletypekind None (Role = 0): No permissions assigned. Guest (Role = 1): Limited access, typically read-only. Reader (Role = 2): Can view items but not make changes. Contributor (Role = 3): Can add and edit items. WebDesigner (Role = 4): Can design and manage site content. Administrator (Role = 5): Full control over the site. Role (UserRoleAssignment). View (Role = 1): Grants read-only access to the document. Edit (Role = 2): Allows the user to edit the document. Owner (Role = 3): Grants full control over the document, including the ability to manage permissions. None (Role = 0): Removes any previously assigned permissions. Step 1 - You need to have broken inheritance first, otherwise this won’t work. API call 1 - Get all the groups from SharePoint Method: Post URI: _api/web/lists/getbytitle('@{variables('VarListname')}')/items(@{variables('VarItemID')})/UpdateDocumentSharingInfo

Thursday, February 20, 2025 | 2 minutes Read
Hero Image
Introduction to blog series - HTTP calls to SharePoint

Introduction Welcome to my blog post series on HTTP SharePoint calls. In this series, we’ll dive into the different types of HTTP calls you can make to SharePoint, including GET, POST, PUT, and DELETE. We’ll explore the necessary permissions required for these calls and how to set them up correctly. Additionally, we’ll cover the essential components of an HTTP request, such as headers and body, and explain how to structure them for successful communication with SharePoint.

Thursday, February 20, 2025 | 1 minute Read
Hero Image
Filter on date column with random years on SharePoint

Usecase You have a SharePoint list with birthdays, on a date column, but dont know how to filter on them to show the last few days or upcoming few days if someone has (had) their birthday. I couldnt figure out how to do this, and then a colleague of mine Remco Bruijstens (thank you!) suggested this method, and after testing it worked. Kudos to him, and I wanted to share with you how to accomplish this.

Tuesday, February 20, 2024 | 2 minutes Read
Hero Image
Custom document link sharing with SharePoint and Power Automate

Usecase You need to share a file from SharePoint to an external user, in an automated process. No manual ‘create link’ actions needed on the SharePoint site. You can then email this link to your external client. Default on Power automate for a sharing link for SharePoint, is to set the Link Scope to either: Anyone with the link (including anonymous) People in your organization This explains how you can use the ‘people with existing access’ sharing type.

Monday, September 11, 2023 | 2 minutes Read