To be able to import terms from a term set in one tenant to another tenant (for example if you have a test tenant and a production tenant), you need some way of exporting the term set from the source tenant. The import file should be in .csv format. The PnP PowerShell Module has commands … Continue reading Export SharePoint term set to CSV file with PnP PowerShell
Author: greian
PnP Search Extension – Rendering a field value
When using the PnP Search Web Parts, you have the possibilty of extending the web part by building custom web components that can be used in the handlebar code. (Read more about PnP Search extensibility here). In the handlebar templates in PnP Search, the values of managed search properties are used to display the search … Continue reading PnP Search Extension – Rendering a field value
Copy file attachments from a SharePoint list item to another in Power Automate
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
umeaworks 