In this article, I will describe how to create an Excel file dynamically with Power Automate and fill it with data from the Common Data Service. Creating those dynamically can be a bit tricky. Therefore, I will provide step by step description of how to do that. Scenario Let’s assume AB Company is using Dynamics… READ MORE
Power Automate is used to automatize actions, it therefore needs to connect to services. Most of them can be accessed using the default connectors without providing any secret or password, but sometimes, you need to operate the authentication yourself. The most common example would be calling Microsoft GraphAPI using the HTTP connector. In this case… READ MORE
In SharePoint Online, whenever you create a library and turn on “Require check-out” before editing documents option or not, users are able to open files for collaboration in browsers or in their local Office clients. When they do that, the file is getting locked from access that could lead to its metadata changes. If you… READ MORE
In this blog post I will show how to use Power Automate to create an attribute-based ID in Microsoft Lists. Attribute-based translates to business readable with formatting. This pattern is based on work I did at my previous employer where the List was being used for data imports into a legacy application that required a:… READ MORE
If until now one of the flows that I have helped to configure the most are those that are launched manually from a SharePoint element , Microsoft has surprised me again and without a doubt the new trigger for Teams will give a lot to talk about and will be the protagonist in many business solutions . Just a month… READ MORE
This topic has been continuously raised by multiple people I’ve been talking to. How can a user be mentioned in Microsoft Teams when a message is sent from Power Automate? This issue seemed to never been really possible for us, Power Users, until couple days ago Microsoft released new action in Microsoft Teams set in… READ MORE
Recently while developing a flow for SharePoint list process, I came across a requirement to set unique permissions for SharePoint list items. So, in this blog post I will share a walk through on how to set unique permissions for item in SharePoint using Power Automate. Walkthrough In your flow add the actions as per… READ MORE
How to overcome the Power Automate Approvals 30 days limit post is my attempt to show how to deal with this Flow annoying 30 days limit. General idea of approach First Flow – create new Audit item Second Flow – track Approval Trigger conditions Wait for an approval configuration Timeout configuration Approvals reminders consideration Flow result… READ MORE
Let’s take a simple use case where you need to have a Microsoft Team created in Teams and have the Project Members added to the Microsoft Teams’ Project Team. You can simply do this using 2 simple Flows in Power Automate Scenario & Setup in Power Automate If you are a PSA Customer, you would… READ MORE
Many of us will work in organisations that have a global presence and therefore may have a need to know the value of something in a local currency / Exchange Rate Conversion. There isn’t any out of the box way to convert a base currency to another currency in Power Automate, so I wanted to… READ MORE
