web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Automate Office Script with Inp...

Power Automate

Unanswered

Office Script with Input Parameters and Object Outup

(0) Share

Report

Report

Posted on by mgrachii

206

Hi,

I am using Office Scripts to return data to power automate, they work great if the return data type is string or number. When I try to return an object, (eg JSON), the script goes crazy and my input parameters are no longer recognized. If i stringify the JSON and return as string it works. Do you know if this is a known issue with Object responses? or am I doing something wrong

My script receives 2 JSON parameters, then process this data and returns something back to me in Power Automate.

This works:

function main(workbook: ExcelScript.Workbook, projectsJSON: ProjectsInterface[], tasksJSON: TasksInterface[]😞 string {

Power Automate prompts properly my parameters and runs with no issues, returns string perfectly

This makes my script parameters to desapear from Power Automate interface:

function main(workbook: ExcelScript.Workbook, projectsJSON: ProjectsInterface[], tasksJSON: TasksInterface[]): object {

My input parameters are no longer prompted (and I get the error below)

Categories:

I have the same question (0)

All responses Img

All responses (1)

Answers Img

Answers (0)

Random1231 6 on at

Like (1)

Report
Copy link

Link copied!
Hi mgrachii,
Try to NOT define the return type of your function and return whatever you should. It works for me.
(workbook: ExcelScript.Workbook, projectsJSON: ProjectsInterface[], tasksJSON: TasksInterface[]) { ... return { "whatever" : "whatever", .... }; }

Was this reply helpful? Yes No

Join the conversation