Skip to content · Zum Inhalt

Power Automate Actions

Power Automate Actions (Action Type 9, Enum Value 9) enable business rules to trigger Microsoft Power Automate flows, creating seamless integration between Business Central business logic and the broader Microsoft Power Platform ecosystem. Power Automate provides hundreds of connectors to Microsoft services (Teams, SharePoint, Outlook, Dynamics 365) and third-party systems (Salesforce, ServiceNow, Dropbox, Twitter, and many others), enabling sophisticated cross-platform workflows without custom code development. This section explains when Power Automate Actions are appropriate, how to create flows that respond to QUALIA Rule Engine triggers, how to configure flows in business rules, and best practices for reliable integration.

16.1 When to Use Power Automate Actions

Power Automate Actions are appropriate when business rules should trigger workflows or integrations that leverage Power Automate's extensive connector ecosystem.

Appropriate Use Cases for Power Automate ActionsMicrosoft Teams Integration for Collaboration: When business events in Business Central should notify Microsoft Teams channels or initiate Teams-based approval workflows, Power Automate Actions provide native integration. Examples include posting high-value order notifications to sales team channels, creating Teams approval requests for manager authorization, notifying support teams when customer issues are logged, or initiating Teams meetings based on business events.

SharePoint Document Management Integration: When Business Central transactions should trigger SharePoint document operations (creating folders, uploading files, updating document metadata, initiating SharePoint approval workflows), Power Automate Actions connect the systems. Examples include automatically creating SharePoint folders for new customers, uploading order confirmations to customer-specific libraries, or triggering document approval workflows for contracts.

Advanced Email Workflows with Outlook Integration: While QUALIA Rule Engine provides built-in Email actions, Power Automate enables more sophisticated email scenarios including calendar integration, meeting scheduling, email with rich HTML formatting, template-based emails with dynamic content, or multi-step email workflows with conditional logic.

Third-Party System Integration via Connectors: Power Automate provides pre-built connectors to hundreds of third-party systems. Power Automate Actions enable integration scenarios such as creating Salesforce opportunities when Business Central quotes are generated, logging ServiceNow tickets when errors occur, synchronizing data with external databases, posting updates to social media platforms, or triggering external approval platforms.

Mobile Notifications and Mobile-Friendly Approvals: Power Automate's mobile app enables push notifications and mobile approval interfaces. Power Automate Actions can trigger mobile notifications for managers, enable one-tap mobile approvals for transactions, send mobile alerts for urgent situations, or provide mobile-friendly data access.

Cross-Platform Workflow Orchestration: When business processes span multiple systems and platforms, Power Automate provides the orchestration layer. Examples include multi-system approval workflows (Business Central → Teams → SharePoint → Dynamics 365), data synchronization across platforms, event-driven integration patterns, or complex conditional routing based on business logic.

When NOT to Use Power Automate ActionsSimple Email Notifications: If the requirement is simply sending email to specified addresses, use Email actions instead. Power Automate Actions add complexity and external dependencies that are unnecessary for basic email.

Requirements Satisfied by Standard Actions: If the requirement can be met using Error, Message, Assign, or other built-in action types, use standard actions rather than adding Power Automate dependency.

High-Frequency Operations: Power Automate has usage limits and throttling thresholds. If an action would trigger flows hundreds or thousands of times per day, verify that your Power Automate licensing and capacity can support the volume, and consider whether alternative designs would be more appropriate.

Real-Time Synchronous Requirements: Power Automate flows execute asynchronously (they run in the background after the Business Central transaction completes). If your requirement demands that external processing must complete before the Business Central transaction can proceed, Power Automate Actions are not appropriate—consider Custom Actions with synchronous API calls instead.

Highly Sensitive Data: Power Automate flows process data outside Business Central, potentially traversing multiple systems and connectors. Ensure your organization's data security and privacy policies permit this data movement before using Power Automate Actions for sensitive information.

16.2 Prerequisites for Power Automate Integration

System PrerequisitesPower Automate Licensing: Your organization must have appropriate Microsoft Power Automate licensing. Many flows can execute with the Power Automate capabilities included in Microsoft 365 subscriptions, but premium connectors require Power Automate Per-User or Per-Flow licenses.

Business Central Connector Configuration: The Power Automate Business Central connector must be properly configured with authentication credentials that allow flows to access Business Central data.

Network Connectivity: Power Automate cloud services must have network connectivity to your Business Central environment. For on-premises Business Central, this may require firewall configuration or on-premises data gateways.

QUALIA Rule Engine PrerequisitesPermission Set Assignment: Users or user groups must be assigned the QUA Power Automate Connector UnLicensed permission set. This permission set grants the necessary permissions to execute Power Automate Actions from business rules.

Flow URL Configuration: Each Power Automate flow that receives triggers from QUALIA Rule Engine must have its webhook URL configured in the business rule. This URL is generated when you create the flow and must be copied into the QUALIA configuration.

16.3 Creating Flows in Power Automate That Respond to QUALIA Triggers

This section provides guidance for creating Power Automate flows that can be triggered by QUALIA Rule Engine business rules.

Step 1: Create a New Flow in Power Automate

Open Power Automate (https://make.powerautomate.com)

Select Create → Automated cloud flow

Provide a descriptive flow name (for example, "QUALIA - High Value Order Notification")

Skip the trigger selection for now (click Skip)

Step 2: Add HTTP Request Trigger

In the flow designer, click Add a trigger

Search for "HTTP request"

Select When a HTTP request is received

This trigger allows QUALIA Rule Engine to call the flow via HTTP POST

Step 3: Configure Request Body JSON Schema (Optional)

If you want your flow to receive parameters from QUALIA Rule Engine (for example, order number, customer name, amount), define a JSON schema:

{
    "type": "object",
    "properties": {
        "OrderNo": { "type": "string" },
        "CustomerName": { "type": "string" },
        "Amount": { "type": "number" },
        "UserID": { "type": "string" }
    }
}

This schema enables Power Automate to parse incoming parameters as dynamic content you can use in subsequent flow actions.

Step 4: Add Flow Actions

Add the actions your flow should perform. Common examples:

Post Message to Teams Channel:

Action: Post message in a chat or channel (Teams connector)

Configuration:

Team: Select your team

Channel: Select the channel

Message: Compose message using dynamic content from HTTP request

Example message:

High Value Order Alert
Order No.: [OrderNo dynamic content]
Customer: [CustomerName dynamic content]
Amount: $[Amount dynamic content]
Created by: [UserID dynamic content]

Send Approval Request:

Action: Start and wait for an approval (Approvals connector)

Configuration:

Approval type: Approve/Reject - First to respond

Title: "Approve Order [OrderNo]"

Assigned to: [email protected]

Details: Include order information from dynamic content

Create SharePoint Item:

Action: Create item (SharePoint connector)

Configuration:

Site: Your SharePoint site

List: Your list name

Fields: Map dynamic content to SharePoint columns

Step 5: Save Flow and Copy HTTP URL

Save the flow

Expand the When a HTTP request is received trigger

Copy the HTTP POST URL that Power Automate generates

This URL is what you will configure in QUALIA Rule Engine

The URL looks similar to:

Step 6: Test the Flow

Before connecting QUALIA Rule Engine, test the flow:

Use the Power Automate "Test" feature

Send a test HTTP request with sample JSON data

Verify the flow executes and performs expected actions

Fix any errors before proceeding

16.4 Configuring Power Automate Actions in QUALIA Business Rules

Once you have created and tested a Power Automate flow, configure the business rule to trigger it.

Step 1: Create or Open the Business Rule

Navigate to the Business Rules page in Business Central

Open the Business Rule Set that should trigger the Power Automate flow

Create a new Business Rule or open an existing rule

Configure the Condition that determines when the flow should be triggered

Step 2: Add a New Power Automate Action

In the Actions section of the Business Rule, create a new action line

Set the Action Type field to Power Automate Flow (this is Action Type 9 in the enum)

The new action line is now configured to trigger a flow when the condition evaluates to TRUE

Step 3: Configure Flow Details

In the action line, locate the Action Code or Flow ID field

Enter a new code (for example, FLOW001) or select an existing flow configuration

Open the Power Automate Flow Detail card by selecting the Action Code field

On the Flow Detail card, configure:

Code: Unique identifier for this flow configuration

Description: Descriptive name (for example, "Teams Notification for High Value Orders")

Flow URL: Paste the HTTP POST URL you copied from Power Automate (the webhook URL from the "When a HTTP request is received" trigger)

Step 4: Configure Parameters to Pass to Flow

If your flow expects JSON parameters, configure them:

Locate the Parameters or Request Body section on the Flow Detail card

Enter the JSON that should be sent to the flow

Use placeholder syntax to include dynamic values:

{
    "OrderNo": "[36:3]",
    "CustomerName": "[36:79]",
    "Amount": [36:61],
    "UserID": "[USERID]"
}

QUALIA Rule Engine will substitute placeholders with actual values before sending the HTTP request to Power Automate.

Step 5: Save and Test

Save the Flow Detail card

Save the Business Rule

Test by creating a Business Central transaction that meets the condition

Verify the Power Automate flow runs

Check Power Automate run history for successful execution

Verify the flow performed expected actions (Teams message posted, approval created, etc.)

16.5 Troubleshooting Power Automate Integration

Flow Does Not TriggerCheck Permission Set: Verify users have the QUA Power Automate Connector UnLicensed permission set.

Verify Flow URL: Ensure the webhook URL is copied correctly and completely (these URLs are very long).

Check Business Rule Condition: Verify the condition evaluates to TRUE.

Review Validation Log: Check for error messages indicating why the HTTP request failed.

Flow Runs But Parameters Are IncorrectVerify JSON Syntax: Ensure the parameter JSON is valid. Use a JSON validator if needed.

Check Placeholder Syntax: Verify placeholders use correct syntax [TableID:FieldID].

Verify Data Types: Numeric values should not have quotes, text values should have quotes.

Flow Runs But Actions FailCheck Flow Run History: Open Power Automate and view the flow's run history to see detailed error messages.

Verify Connector Authentication: Ensure Power Automate connectors are properly authenticated and authorized.

Check Data Validity: Verify data passed from Business Central is valid for the flow actions (for example, email addresses are properly formatted).

16.6 Best Practices for Power Automate Integration

Descriptive Flow Names

Name flows clearly so their purpose is obvious: ✅ Good: "QUALIA - Sales Order Approval Request" ✅ Good: "BC High Value Order → Teams Notification" ❌ Bad: "Flow 1"

Error Handling in Flows

Configure error handling in your flows:

Add "Configure run after" settings to handle failures gracefully

Add email notifications to administrators when flows fail

Log errors to SharePoint lists or databases for tracking

Monitoring and Alerts

Monitor Power Automate integration:

Review flow run history regularly

Set up alerts for flow failures

Monitor flow execution frequency

Watch for throttling warnings

Documentation

Document each integration:

What the flow does

When it triggers (which business rule condition)

What systems it interacts with

Who owns the flow

How to troubleshoot problems

Testing Before Production

Always test flows in sandbox:

Verify flows execute correctly

Test with various data values

Verify parameter passing works

Check error handling

Confirm acceptable performance