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
Month: March 2020
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