Tag: automation
-
Power Automate: Auto Create Excel Table Based On Dynamic Content (With Excel Automation Script)
Learn how to efficiently retrieve the final index of utilized rows and columns within an Excel file, even in the absence of a table. This guide demonstrates the utilization of Power Automate in conjunction with Excel Automation Script to create a table based on the indexes being used in multiple sheets. By employing this flow,…
-
Power Automate: Extract, Combine, Join and Filter array values
In today’s blog post, I’ll dive into working with arrays and the different methods to extract, combine, join and filter values of multiple arrays. In this guide, you will get to learn some of the most common ways (personal experience) to work with arrays in Power Automate. Whether you’re working with small or large arrays,…
-
Power Automate: Store your API Access tokens in Azure Key Vaults and automatically renew them!
Getting Started: An Introduction to create Key Vaults for Beginners Lets start with creating an Azure key vault, with two key vaults secrets. Make your way and login to the Azure portal (Microsoft Azure) and follow below: Great! Now we’ve setup the Azure Key Vault, next we’re going to use the Azure App registration to…