Office Script providing values to Power automate flow
This describes, how to take value from Office Script and send it to Power Automate flow, which will use it.
Office Script generating values
Lets say you have this script Office Script:
-
function main(workbook: ExcelScript.Workbook,){console.log(1) //console outputreturn(2) // result}
It generates two values – console output (number 1) and content of return function (number 2).
Use in Power Automate
The input for Power Automate is a “Body” object with this content:
- {“result”:2,”logs”:[“[2022-11-09T18:57:34.1580Z] 1“]}
which is quite difficult to read, it would be better to keep “results” and “logs” separately.
In Power Automate we will use the Parse JSON step, which splits the body into components.
then we can reference these JSON components from any following step:
For example, this generates this mail:
