Logo Power Platform Tips & Tricks
  • Home
  • About
  • Posts
  • Tags
  • Glossary
  • Speaking
  • Videos
  • Dark Theme
    Light Theme Dark Theme System Theme
Logo Inverted Logo
  • Posts
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.

  • SharePoint HTTP series
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.

  • SharePoint HTTP series
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.

  • SharePoint HTTP series
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.

  • SharePoint HTTP series
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

  • SharePoint HTTP series
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.

  • SharePoint HTTP series
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.

  • Variables
  • Power Automate
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.

  • Copilot Studio
  • Generative answers
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.

  • Canvas app
  • Model Driven app
  • Dynamics365
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.

  • Javascript
  • Power Automate
  • Power Pages
  • Dataverse
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:

  • RegEx
  • Power Automate
Thursday, July 11, 2024 | 1 minute Read
Hero Image
How to use parameters in an embedded Power BI link

My scenario: This is an addition to my earlier blog, and with a few more parameters you can use. Credits go to https://community.fabric.microsoft.com/t5/Service/All-possible-Power-BI-Service-embed-URL-parameters/m-p/3053763 but I did want to share as well. I’m struggeling to fit a canvas app with a powerbi tile that has an embedded report into a teams app (gotta love it) and my report wont fully fit. I’m trying to find the magic combo of these parameters. How do I use these parameters? Get the embedded URL from your report (Go to export, and copy the embed link)

  • Canvas App
  • Power BI
Monday, July 1, 2024 | 2 minutes Read
  • ««
  • «
  • 1
  • 2
  • 3
  • 4
  • 5
  • »
  • »»
Navigation
  • About
  • Tags
  • Glossary
  • Speaking
  • Videos
Contact me:
  • Bluesky: nathleenders.bsky.social
  • info@nathalieleenders.com
  • Nathalie-Leenders
  • Nathalie Leenders

Toha Theme Logo Toha
© 2025 Copyright Nathalie Leenders. All Rights Reserved.
Powered by Hugo Logo