Hero Image
Blog series - HTTP calls to SharePoint - Working with folders

Working with folders and the SharePoint API When working with the SharePoint API, handling folders can sometimes be tricky, especially when dealing with deeply nested structures. In this post, we’ll explore how to dynamically grab the file location regardless of how deep it is in the root or folder structure. We’ll also cover how to handle common issues like permission errors. Dynamically Grabbing the File Location To work with folders in the SharePoint API, you need to use the full path. This ensures that you can dynamically grab the file location, no matter how deep it is within the root or folder structure.

Thursday, February 20, 2025 | 2 minutes Read
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
Adding a decimal count to your Power Automate Flow (Float/Increment variable)

I’ve explained how to count in a variable, but how do you count in a decimal? I had a usecase, where we wanted to create a version number metadata field. We could of course use an integer, count using increment, and upload to the field, however that only does ‘major’ counts i.e 1.0 to 2.0 to 3.0 etc. How do I count in minor, decimals, from 0.1 to 0.2 to 03 or even 0.01 to 0.02? To do this, you can follow the same logic, but use a float value instead of integer.

Monday, November 4, 2024 | 1 minute Read
Hero Image
New options for Gen AI and Bing AI Search

Usecase You’re trying to use Generative AI features in Copilot Studio, however it says it’s not supported. How do you fix this? Enable the settings for your environment You need to be a Power Platform admin for this. Go to the Power Platform admin center CLick on your environment. On the lower right corner, enable these 2 settings: Now you can use GenAI in your Copilot Studio bot! It worked before (about a month ago at the time of this post) but it’s not been adding to these options.

Wednesday, September 4, 2024 | 1 minute Read
Hero Image
How to use the PDF Viewer, to view PDF's in a Model Driven app from an attachment column

Usecase My PDF viewer works in the canvas app, but not when I embed it Show image 0/0 in MDA The beginning I had a need, to display a pdf from a Dataverse attachment column in a Model driven app form. I had looked at many different PCF Components (which are totally awesome, you should really check them out!) However these only work on Notes with attachments. My dataverse table/solution uses a files column.

Monday, August 12, 2024 | 3 minutes Read
Hero Image
Calling a Power Automate Cloud flow, from Power Pages forms (!) using Javascript

Calling a Power Automate flow from a dataverse form, in a Power Page form Sounds easy right? Trust me it’s not, but I hope this helps. I have had tremendous help from my colleague Laurens Hoogendoorn, who is completely awesome and helps me run with javascript (see what I did there) before learning how to crawl or walk. LOL. Laurens, you are the best! So, let me start at the beginning.

Wednesday, July 17, 2024 | 4 minutes Read
Hero Image
How to use regex in Power Automate Cloud flows

I had a client scenario, where I needed to grab a 6-digit number from an incoming email subject. It wont always be in the same place, and also possibly not be the only digits. So I couldnt use trim, length or other that I could think off. Unfortunately, or luckily, depending on how you look at it, my dear friend Cat Schneider introduced me to regex Thankfully someone within my company helped me guide a regex expression I could use, but I do want to share this awesome resource:

Thursday, July 11, 2024 | 1 minute Read