Trigger: When an order is created

iMIS Power Suite - Power Automate Connector

Review the following on creating a trigger that fires when an order is created:

Type: Trigger
Occurs: Whenever a new order record is added to iMIS

📘
Note
An edit/update will not fire this trigger

Polling interval: 2 minutes
Payload: The new Order record that was just inserted (all fields on the Orders table)
Splitting: The automation will run once for each new record.

👍
Example
If 5 activities are created in the 2-minute window, 5 separate automation runs will be started.

Trigger Filtering

To limit the trigger to only certain orders,add a trigger condition which will prevent the trigger from executing unless all conditions are met. Do the following:

On the trigger item, press the ... menu button and choose Settings.
In the Trigger Conditions section, specify a trigger condition.

👍
Example
To filter the trigger to only run for certain order types, enter the following condition: @equals(triggerBody()?['orderTypeCode'], 'MEETING')

When finished, press Done.

📘
Note
This works on any trigger, not just the Orders trigger.

Outputs

Code Name	Field Name	Type
address1	Ship To Address Line 1	string
address2	Ship To Address Line 2	string
address3	Ship To Address Line 3	string
addressFormat	Ship To Address Format Code	integer
affectInventory	Affects Inventory	boolean
balance	Balance Amount	number
batchNumber	Batch Number	string
billToId	Bill To iMIS ID	string
city	Ship To Address City	string
company	Company Name	string
companyId	Company iMIS ID	string
companyMemberType	Company Member Type	string
companySort	Company Sort Code	string
country	Ship To Address Country	string
customerReference	Customer Reference	string
discountCode	Discount Code	string
email	Ship To Email Address	string
enteredBy	Entered By	string
enteredDateTime	Entered Date/Time	string
entityCode	Entity Code	string
Ufreight1	Freight 1 Amount	number
Ufreight2	Freight 2 Amount	number
freightTax	Freight Tax Amount	number
fullAddress	Shipp To Full Address	string
fullName	Ship To Full Name	string
handling1	Handling 1 Amount	number
handling2	Handling 2 Amount	number
handlingTax	Handling Tax Amount	number
holdCode	Hold Code	string
holdComment	Hold Comment	string
holdFlag	Is Held?	boolean
invoiceDate	Invoice Date	string
invoiceNumber	Invoice Number	integer
invoiceReferenceNumber	Invoice Reference Number	integer
lineTotal	Line Total Amount	number
memberType	Ship To Member Type	string
notes	Order Notes	string
orderDate	Order Date	string
orderNumber	Order Number	number
orderTypeCode	Order Type Code	string
payType	Pay Type	string
phone	Ship To Phone	string
shipMethod	Shipping Method	string
shipPapersDateTime	Ship Papers Date	string
shippedDateTime	Shipped Date	string
shipToId	Ship To iMIS ID	string
sourceCode	Source Code	string
sourceSystem	Source System	string
stage	Order Stage	string
stateProvince	Ship To State/Province	string
status	Order Status	string
tax1	Tax 1 Amount	number
tax2	Tax 2 Amount	number
tax3	Tax 3 Amount	number
taxAuthor1	Tax 1 Author	string
taxAuthor2	Tax 2 Author	string
taxAuthor3	Tax 3 Author	string
taxExempt	Tax Exempt	string
taxRate1	Tax 1 Rate	number
taxRate2	Tax 2 Rate	number
taxRate3	Tax 3 Rate	number
taxRateFh	Tax Rate	number
termsCode	Terms Code	string
title	Order Title	string
totalCharges	Order Total Charges	number
totalPayments	Order Total Payments	number
totalQuantityBackordered	Total Quantity Backordered	integer
totalQuantityOrdered	Total Quantity Ordered	integer
totalWeight	Total Weight	number
undiscountedTotal	Undiscounted Total	number
vatTaxCodeFh	VAT Tax Code	string
zip	Ship To Postal Code	string