Skip to main content

Control Nooxl Apps with Microsoft Power Automate

Nooxl Apps exposes a REST API so external applications can drive its automation — importing, exporting, copying data, and calculating models. Microsoft Power Automate is one such application.

What is Power Automate?​

Power Automate lets users build automation rules ("flows") without writing code, to automate repetitive tasks such as notifications, data synchronization, and business processes. It is part of the Microsoft Power Platform.

Demo solution​

A sample solution (NooxlAppsAutomate ZIP, available from the live docs) can be imported into Microsoft Power Automate and tested.

Screenshot placeholder

  • 1 Import the Nooxl solution ZIP.

How the flow uses the REST API​

The flow has two parts: authenticate, then calculate a model.

Authenticate​

Use the authenticate endpoint. For the demo:

Flow 'authenticate' - demo parameters
nooxlApiHostName: https://ncs-demo.nooxl.com
nooxlApiLogin:    API-Tester
nooxlApiPassword: ivtP@t>UN>KF9

Parse the response to a JSON object and take the Token for the next step's bearer authorization.

Model calculate​

Use the model calculate endpoint. The parameters select the model (modelName), the dataset (modelSelections), the inputs (dataInputs), and the output ranges (dataOutputMarkupNames):

Flow 'model calculate' - demo body
{
  "modelName": "Cash flow",
  "modelSelections": [
    { "dataLabelName": "2024-01" },
    { "dataLabelName": "Asset A" }
  ],
  "dataInputs": [
    { "markupName": "Usage Inputs",
      "cellValues": [
        ["810","16","","20.00","4%"],
        ["245","4","","25.75","4%"]
      ]
    }
  ],
  "dataOutputMarkupNames": [
    "Total annual revenue Outputs", "Total annual expense Outputs"
  ],
  "modelOptions": { "saveModel": false }
}

With saveModel the model is saved if permitted, triggering any actions in the model (for example creating a new version and copying data). The flow receives the output ranges and can parse the JSON to reuse individual values.