User FAQs

If you have a question, please send it to us.

1) What is Power Automate ?

Office Scripts with Power Automate:

link - learn.microsoft.com/en-us/office/dev/scripts/resources/samples/automate-tasks-on-all-excel-files-in-folder 
link - learn.microsoft.com/en-us/office/dev/scripts/resources/samples/combine-worksheets-into-single-workbook 
link - learn.microsoft.com/en-us/office/dev/scripts/resources/samples/convert-csv 
link - learn.microsoft.com/en-us/office/dev/scripts/resources/samples/excel-cross-reference 
link - learn.microsoft.com/en-us/office/dev/scripts/resources/samples/email-images-chart-table 

Power Automate incompatibility error

async function main(context: Excel.RequestContext) { 
[Power Automate incompatibility error] 
Parameter is required to have type: ExcelScript.Workbook 
(Office Scripts Error) 

Since the Simplified Syntax has been introduced the old syntax no longer works.
The function declaration must be replaced with the following:

function main(workbook: ExcelScript.Workbook) {