The Case We are using Power Automate to copy an item from one list to another. The original item might have file attachments, so, in addition to copy the fields, we need to also copy the attachments. This cannot be done in the regular Create Item SharePoint action, so we needed to find another way. … Continue reading Copy file attachments from a SharePoint list item to another in Power Automate
Show/hide custom action with JSON Formatter in SharePoint based on file type
The Case I had a customer case where they wanted to show or hide a setValue custom action (customRowAction) conditionally based on the type of document in a SharePoint document library. The custom action without any conditions applied looks like this: The requirement was that they wanted to show this toggle button (setValue custom row … Continue reading Show/hide custom action with JSON Formatter in SharePoint based on file type
Test SPFx web parts on modern page directly
The case When developing web parts with SharePoint Framework (SPFx) you use the workbench both locally and online on a SharePoint site (/_layouts/15/workbench.aspx) to test and debug. Sometimes the workbench is limiting because differences in layout (canvas width), use of theme colors, etc. We would therefore like to be able to test and debug the … Continue reading Test SPFx web parts on modern page directly
Get the ID of the first item of a SharePoint query with Power Automate
The Case I have a flow in Power Automate where I need to lookup an item in a SharePoint list based on two lookup columns (in this example, the two lookup columns are called Patient and Exercise). I know that there will be one and only one item in the list with the combination of … Continue reading Get the ID of the first item of a SharePoint query with Power Automate
Copy an action from one flow to another in Microsoft Power Automate
The Case Often, one needs to create different flows in Power Automate that uses the same type of actions that you have used before. To be able to reuse actions, we want to be able to copy an action from one flow to another The Solution Microsoft have introduced a function in Power Automate that … Continue reading Copy an action from one flow to another in Microsoft Power Automate
Changing the URL of a SharePoint List using PnP PowerShell
The Case Sometimes you want to change the url name of a list in SharePoint Online. For example, if your list name is "Order", the site relative url to the list is "/order", and you want to change the name to "Orders", only the list name can be changed in the SharePoint GUI. The URL … Continue reading Changing the URL of a SharePoint List using PnP PowerShell
Trigger Azure Function repeatedly with Do Until in Power Automate
The Case In a project I was working on I had the requirement that we needed to run a validation of data that was added to a list in SharePoint, and perform some advanced logic to update several other lists based on the input. The requirement was to run the check every five minutes for … Continue reading Trigger Azure Function repeatedly with Do Until in Power Automate
Load fields dynamically when using SharePoint CSOM
The Case When querying the SharePoint CSOM API:s it is common that you want to fetch specific fields. If you have lots of queries going on toward SharePoint, you should find a way to avoid repetitive code (using the DRY principle) by creating a method that accepts a list of field names to be fetched. … Continue reading Load fields dynamically when using SharePoint CSOM
Creating a SharePoint App registration that never expires
The Case I am building an Azure Function that shall communicate with SharePoint Online using CSOM. The function shall have access to read and write information to lists in a specific SharePoint site collection. When you are using the standard method for creating a new SharePoint App Registration using the form located under /_layouts/15/AppRegNew.aspx, the … Continue reading Creating a SharePoint App registration that never expires
Linking to other Apps in Ionic 4
Sometimes, you need to insert a link from your own Ionic App to another app that might or might not be installed on the users phone. To make this work, you need to check if the app exists on the users phone and insert a link to the app or the web based on the … Continue reading Linking to other Apps in Ionic 4