Troubleshooting


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) { 

The property 'address' is not available

The property "address" is not available. 
Before reading the property's value, call the load method on the containing object
and call "context.sync()" on the associated request context.

Check that you have included an "await" before all the context.sync() calls



© 2022 Better Solutions Limited. All Rights Reserved. © 2022 Better Solutions Limited TopPrevNext