I was recently trying to use Power Automate to write to an Excel worksheet, when I found out that the file is password protected. I was trying to find any action to let me unlock it, but I failed. After some research I realized this can be done using the power of Office Scripts!
In my previous post I was describing a solution to provision SharePoint lists dynamically and also to set their permissions. However, I want to share as well the solution that will let you to create list items using XML data.
In this blog post I would like to share with you a cool solution I have recently built for my customer, that allows dynamic creation of lists based on existing templates, together with setting all needed metadata and permissions.
Some time ago I have recorded a video about using the pre-deployment actions in Power Platform Pipelines. These actions would allow you to create e.g. approval workflow. In this post I am describing actions, that the mentioned workflow is using.
The announced with the February 2023 release, new Microsoft Dataverse schema for storing Power Automate Desktop data, so called “v2”, requires all desktop flows to be upgraded by Q1 2024. I did this already and faced several challenges, that I would like to share with you.
This post directly refers to my latest video, where I am describing the missing steps required to really successfully reassign a task to a regular Environment Maker using Power Automate cloud flows and approvals’ data stored in Microsoft Dataverse.