Part 3 – Adding SharePoint List Data To an Excel Sheet by Passing it to an Excel Script Using Power Automate

In our previous blog post, we passed(returned) the data from Excel Script into Power Automate. In this post, I will explain how to use SharePoint list as a data source and pass data (populate a template Excel) using office scripts and then use Muhimbi Converter to PDF to generate a PDF file of your Quotations.

Part 2 – Pass data from script to Power Automate

Now that we have understood the Basics of Excel Office Script, lets leverage Office Scripts in Power Automate . In this blog, we will see how we can return information from Excel File using Office Script to Power Automate workflow.

Part 1 – Basics of Excel Office Scripts

Excel is a powerful tool that has become the most well-established tool in business processes be it for analysing reports, budgeting, or organizing client sales lists. Excel Office Scripts in the web let you automate your day-to-day tasks (same time) by configuring\recording scripts and automating you day to day activities.