-
Creating Customized AI Agents in Copilot Studio
With the rise of Microsoft Copilot, the usage of customizable chatbots powered by AI gained attention from many organizations. As a general purpose chatbot, Copilot can save time with many daily tasks, such as drafting emails, summarizing meeting notes or finding documents in OneDrive or SharePoint, but it would be even better if we could…
-
How to send bulk emails from an Excel table using Power Automate
One of the most time-consuming tasks for many departments is to send multiple emails that follow a default template, changing only a few fields. This is a very common scenario for status updates, appointment reminders, follow-ups, and notifications in general. These tasks are not only repetitive and tedious, but when handled manually, there is an…
-
Referencing SharePoint and Dataverse columns in Power Automate
When building flows in Power Automate, we often need to reference columns from SharePoint Lists or Dataverse tables. This is necessary for various tasks, such as filter queries, select queries, trigger conditions or when we simply want to access individual column data within expressions. In most scenarios, however, the column names used by Power Automate…
-
Managing worksheets in Office Scripts
As a solution for automating tasks within Excel spreadsheets, Office Scripts can help you to interact and manage worksheets. These interactions with worksheets can also be triggered from Power Automate, enabling you to integrate Excel automations into your workflows. In this article, you will learn how to perform a few useful tasks related to worksheets…
-
How to cancel Power Automate flow run linked to Approval Requests
Power Automate is a great tool for managing approval processes, allowing you to create approval requests, wait for a response or cancel it. One of the main actions for handling approvals is the Start and wait for an approval, which creates a new approval request and keeps the flow running until it is responded. However,…
-
Capture modifications to specific files in Power Automate
Many business processes are initialized by a file change in a SharePoint Document Library. However, when it comes to streamline these processes with Power Automate, the available triggers retrieve all files from a specific folder (including its subfolders), without providing a clear option to limit the flow to capture only the changes made to a…
-
Getting started with Solutions in Power Platform
As a set of low code tool, Power Platform is great for any “non-IT-experts” enhance their productivity with automations, applications, AI agents and websites, and all of that with a very smooth learning curve. However, once you start to work with more complex projects that may combine different Power Platform assets, such as Power Apps,…
-
Approval requests above the 30 days limit in Power Automate
Power Automate is a great tool when it comes to manage both simple or complex approval processes, since it contains a default Microsoft connector supports different approval types. One of the most useful features is the Start and wait for an approval action, which issues an approval request and pauses the flow until it is…
-
Populating an Excel table from a Microsoft Forms submission
How many processes there are in your organization where a customer or an employee must fill out a form or a document, with data then transferred into an Excel table, SharePoint list, or database? This is a common scenario, and many companies still handle it manually, risking errors in the data entry process and dedicating…
-
Reading data from Excel tables with Office Scripts
By default, tasks related to Excel tables can be integrated into low-code automation tools, such as Power Automate. However, for more advanced scenarios, you may need to rely on Office Scripts, which provides you with a wide range of alternatives to automate not only operations in Excel tables, but also in individual ranges, charts, worksheets…
