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.
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.
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.