MADIC dynamics Knowledge Hub Webinar on Tuesday 17th September 2024: How to Create a Multi-Company Report in Jet Reports

MADIC dynamicsHere at MADIC dynamics we will be presenting a Knowledge Hub Webinar at 1400 UK time on Tuesday next week.

Learn how to use Jet Reports to create a multicompany report from Microsoft Dynamics 365 Business Central. This session will cover the steps to consolidate data from multiple companies into a single report.

The webinar is open to everyone who wants to sign up and join:

No sep-2024 events found.

Working with Power Automate: Calculate 30 Days Ago

Power AutomateThis article is part of the Working with Power Automate series I am writing on my experiences working with the Power Automate, which is part of the Power Platform from Microsoft. I also have a related series of articles on Power Automate with Microsoft Dynamics 365 BC.

I was working on a flow a while ago and was using the Microsoft Dynamics 365 Business Central “Find record V3” action and needed to select invoices posted over 30 days ago. To do this I needed to calculate the date 30 days before the present date.

I did some digging and found the required function, which, somewhat counter-intuitively, is called addDays:

Expression showing the entered function to calculate 30 days ago

The function requires three parameters:

  1. timestamp – date to base the calculation on; I used the function utcNow() to get current date/time.
  2. days – the number of days to add or, if a negative number, the number of days to subtract
  3. format – format for the date, which I always use the ISO date format for as this ensures that both UK and US date systens will correctly compare (UK uses dd-MM-yyyy whereas the US uses MM-dd-yyyy).
addDays(utcNow(), -30, 'yyyy-MM-dd')

The expression returns the current date minus 30 allowing me to use this in the filter to only selected invoices older than this date.

Working with Power Automate

Working with Power Automate
What is Power Automate?
What Type of Flow Are Available?
What Type of Cloud Flows Are Available?
Power Automate with Business Central
Working with Power Automate Solutions: What Are Solutions?
Working with Power Automate Solutions: What Types of Solution Are There?
Working with Power Automate Solutions: What is a Solution Publisher?
Working with Power Automate Solutions: Create a Solution Publisher
Working with Power Automate Solutions: Create a Solution
Working with Power Automate Solutions: Publish a Solution
Working with Power Automate Solutions: Version Numbering for Solutions
Working with Power Automate Solutions: Exporting An Unmanaged Solution
Working with Power Automate Solutions: Importing An Unmanaged Solution
Working with Power Automate Solutions: Exporting A Managed Solution
Working with Power Automate Solutions: Importing A Managed Solution
Working with Power Automate Solutions: Change the Managed Properties of a Solution Component
Create a Visio Diagram of a Flow
What Are Environment Variables and Why Should They be Used?
Create an Environment Variable
Create a New Cloud Flow From a Template
Managing Large Flows
What is a Scope?
Example of How to Use a Scope
Best Practice For Using Scopes
Working with Power Automate Child Flows: What are Child Flows?
Working with Power Automate Child Flows: Create a Child Flow
Working with Power Automate Child Flows: Change Run Only Users For Child Flow
Working with Power Automate Child Flows: Add a Child Flow To a Parent Flow
Working with Power Automate Child Flows: Test the Parent/Child Flow Examples
Working with Power Automate Child Flows: Error Encountered Saving a Flow Which Calls a Child Flow
Working with Power Automate Child Flows: Error Encountered With Surprise Extra Parameters for a Child Flow
Calculate 30 Days Ago

In the “For a selected Record V3” Microsoft Dynamics 365 Business Central Trigger in Power Automate, the Record URL is Avalable Without Using “Get url V3” Action

Microsoft Dynamics 365 Business CentralI am writing a few related series at the moment, includong In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… which is a sub-series of the In Microsoft Dynamics 365 Business Central (Power Automate), how do I… series and of the wider In Microsoft Dynamics 365 Business Central, how do I… series which I am posting as I familiarise myself with Microsoft Dynamics 365 Business Central.

Yesterday, I posted at article about using the Get url (V3) action, but realised after posting that the URL for the record from the trigger is available without using this action.

I’m not sure if this is new or if I’ve previously just missed that it was there. In the Dynamic content[/b] available to actions for the For a selected record (V3) trigger:

Get url v3 dynamic content showing the Web Client URL content

This means that for this trigger type, if you want a drill down to the record in the trigger, then you an just use this dynamic content instead of having to use the Get url V3 action.

In Microsoft Dynamics 365 Business Central, how do I…

In Microsoft Dynamics 365 Business Central, how do I…
In Microsoft Dynamics 365 Business Central, how do I… Sign Up For a Trial
In Microsoft Dynamics 365 Business Central, how do I… Get Access to the Microsoft 365 Admin Center
In Microsoft Dynamics 365 Business Central, how do I… Create a Company
In Microsoft Dynamics 365 Business Central, how do I… Copy a Company
In Microsoft Dynamics 365 Business Central, how do I… Switch Between Companies
In Microsoft Dynamics 365 Business Central, how do I… Create a Sandbox Environment With Cronus
In Microsoft Dynamics 365 Business Central, how do I… Access Dynamics BC Admin Centre
In Microsoft Dynamics 365 Business Central, how do I… Create a Sandbox Environment With a Copy of Production
In Microsoft Dynamics 365 Business Central, how do I… Create a User
In Microsoft Dynamics 365 Business Central, how do I… Add a User In 365 Admin Center
In Microsoft Dynamics 365 Business Central, how do I… Add a User in Dynamics BC
In Microsoft Dynamics 365 Business Central, how do I… Change My Role
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Role Center
In Microsoft Dynamics 365 Business Central, how do I… Create an Advanced Evaluation Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Update Rollout Timeline
In Microsoft Dynamics 365 Business Central, how do I… Change the User Experience in a Company from "Essentials" to "Premium"
In Microsoft Dynamics 365 Business Central (Administration), how do I… Set Update Date
In Microsoft Dynamics 365 Business Central, how do I… Hide the Teaching Tips
In Microsoft Dynamics 365 Business Central (Administration), how do I… Set Update Window
In Microsoft Dynamics 365 Business Central (Administration), how do I… Extend Trial
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Search
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Types of Pages Available
In Microsoft Dynamics 365 Business Central (Administration), how do I… Know Which Keyboard Shortcuts Are Available
In Microsoft Dynamics 365 Business Central (Administration), how do I… Switch Between Companies
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use List Pages
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Advanced Filters on Lists
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Card Pages
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the FactBox
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Action Bar
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Company Badges to Identify Companies or Environments
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Document Pages
In Microsoft Dynamics 365 Business Central (Administration), how do I… Use Worksheet Pages
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the On-premise Lifecycle Policy
In Microsoft Dynamics 365 Business Central (Administration), how do I… Start a Free Trial (Updated for the new "customised trial")
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create a Sandbox for a Preview Release
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Posting Groups
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand General Posting Groups
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Specific Posting Groups
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Tax Posting Groups
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create a Tax Business Posting Group
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create a Tax Product Posting Group
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create the Tax Posting Setup
In Microsoft Dynamics 365 Business Central (Administration), how do I… Add a Company Logo
In Microsoft Dynamics 365 Business Central (Administration), how do I… Share a Saved List View
In Microsoft Dynamics 365 Business Central (Administration), how do I… Rename a Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… Rename an Environment
In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete a Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… Delete an Environment
In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore a Deleted Environment
In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore an Environment to a Point in Time
In Microsoft Dynamics 365 Business Central (Administration), how do I… Refresh an Environment
In Microsoft Dynamics 365 Business Central (Administration), how do I… Restore a Deleted Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Approaches to Configuring a New Company
In Microsoft Dynamics 365 Business Central (Administration), how do I… View Two Pages at the Same Time
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Number Series
In Microsoft Dynamics 365 Business Central (Administration), how do I… Maintain Number Series
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand What Data Can Be Deleted
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand the Master Data Management
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Relationships Between Number Series
In Microsoft Dynamics 365 Business Central (Administration), how do I… Create Relationships Between Number Series
In Microsoft Dynamics 365 Business Central (Administration), how do I… Access Business Central
In Microsoft Dynamics 365 Business Central (Administration), how do I… Understand Master Data Management
Using Extended Texts In Microsoft Dynamics 365 Business Central: What are Extended Texts?
In Microsoft Dynamics 365 Business Central (Administration), how do I… Add Branding to Business Central by Setting a Theme
Word Template Mail Merge in Business Central: What is it?
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Personalize a Page
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Remove Personalization from a Page
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Personalize Card Pages
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Understand the Best Way of Customising a Card Page
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Personalize the FactBox
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Personalize the Action Bar
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Understand the Best Way of Personalizing the Action Bar
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Create Customizations for Other Users Using Profiles
In Microsoft Dynamics 365 Business Central (Customisation), how do I… Copy Profile Personalizations to Another Environment
In Microsoft Dynamics 365 Business Central (Customization), how do I… Understand the Difference Between Personalization vs. Design
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand the Chart of Accounts
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand G/L Account Categories and Subcategories
In Microsoft Dynamics 365 Business Central (Financial), how do I… Maintain G/L Account Categories
In Microsoft Dynamics 365 Business Central (Financial), how do I… Create a G/L Account
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand the Types of G/L Account Available
In Microsoft Dynamics 365 Business Central (Financial), how do I… Indent Chart of Accounts
In Microsoft Dynamics 365 Business Central (Finance), how do I… Understand Dimensions
In Microsoft Dynamics 365 Business Central (Financial), how do I… Maintain Dimensions
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Global and Shortcut Dimensions
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Default Dimensions and Priorities
In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure Default Dimensions
In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure Dimension Restrictions
In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure Default Dimension Priorities
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Dimension Combinations
In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure Dimension Combination Blocks
In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure Dimension Combination Limits
In Microsoft Dynamics 365 Business Central (Financial), how do I… Remove Dimension Combination
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand General Journal Templates and Batches
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Dimension Sets
In Microsoft Dynamics 365 Business Central (Financial), how do I… Create a General Business Posting Group
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Accounting Periods and Fiscal Years
In Microsoft Dynamics 365 Business Central (Financial), how do I… Create a General Product Posting Groups
In Microsoft Dynamics 365 Business Central (Financial), how do I… Create a New Fiscal Year
In Microsoft Dynamics 365 Business Central (Financial), how do I… Configure the General Posting Setup
In Microsoft Dynamics 365 Business Central (Financial), how do I… Manually Create a New Fiscal Year
In Microsoft Dynamics 365 Business Central (Financial), how do I… Close a Period
In Microsoft Dynamics 365 Business Central (Financial), how do I… Allow a User to Post into a Closed Period
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand the Recommended Steps for Closing a Period
In Microsoft Dynamics 365 Business Central (Financial), how do I… Close a Fiscal Year
In Microsoft Dynamics 365 Business Central (Financial), how do I… Close the Income Statement
In Microsoft Dynamics 365 Business Central (Financial), how do I… Stop People Posting to a Closed Fiscal Year
In Microsoft Dynamics 365 Business Central (Financial), how do I… Understand Why You Can Post to a Closed Year
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Locations
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Setup Inventory for Locations
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create an Inventory Location
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create an Inventory Posting Group
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create the Inventory Posting Setup
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand the Difference Between Inventory and Warehouse Management
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create a Warehouse User
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand the Different Levels of Inventory and Warehouse Management
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Basic Inventory
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Basic Inventory With Shelves
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Basic Inventory With Bins
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Enable Processing of Inventory Using Bins
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Add Bins to a Location
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process Stock Using Bins
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create Bins in Bulk
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Bin Contents
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Set Default Bin for Items
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Inventory Put-aways in Basic Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Inventory Put-aways
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Put-away from the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process Multiple Inventory Put-aways Using a Batch Job
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Put-away in Two Steps by Releasing the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Put-away Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Inventory Picks in Basic Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Inventory Picks
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Pick from the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process Multiple Inventory Picks Using a Batch Job
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Pick in Two Steps by Releasing the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Receipts in Basic Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process an Inventory Pick Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process a Receipt From the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Receipts
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Post Receipt From a Warehouse Receipt Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Warehouse Receipts and Put-aways in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Receipts and Put-aways in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Post a Receipt From a Warehouse Receipt Document and Post Put-away From a Warehouse Put-away Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand the Warehouse Put-away Worksheet in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Put-aways to Use the Put-away Worksheet in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Create a Warehouse Put-away Worksheet Template
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Put-away Stock Using the Warehouse Put-away Worksheet
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Shipments in Basic Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Process a Shipment from the Source Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Shipments
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Post Shipment From a Warehouse Shipment Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Understand Warehouse Picks and Shipments in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Configure Warehouse Picks and Shipments in Advanced Warehousing
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Post Pick From a Warehouse Pick Document and Post Shipment From a Warehouse Shipment Document
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Use the Pick Worksheet for Warehouse Picks
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Prevent Negative Stock Levels
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Consignment Stock at a Customer Location
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Consignment Stock in My Warehouse
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Manage Stock On a Van
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Mass Insert Item Pictures
In Microsoft Dynamics 365 Business Central (Inventory and Warehouse Management), how do I… Remove a Warehouse/Location from Use
Using Extended Texts In Microsoft Dynamics 365 Business Central: Add Extended Texts to Items
Using Extended Texts In Microsoft Dynamics 365 Business Central: Add Extended Texts to Stockkeepping Units
Using Extended Texts In Microsoft Dynamics 365 Business Central: Enable Item Extended Texts to be Added to Transactions Automatically
In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Create a Vendor Posting Group
In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Produce a Goods Received Not Invoiced Report
In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Keep Invoiced Purchase Orders
In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Understand Dates on Purchase Invoices
In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Override VAT on a Purchase Invoice
In Microsoft Dynamics 365 Business Central (Purchasing), how do I… Assign Number Series in Purchasing
Using Extended Texts In Microsoft Dynamics 365 Business Central: Create a Purchasing Transaction with Manually Added Extended Texts
In Microsoft Dynamics 365 Business Central (Sales), how do I… Create a Customer Posting Group
In Microsoft Dynamics 365 Business Central (Sales), how do I… Produce a Goods Shipped Not Invoiced Report
In Microsoft Dynamics 365 Business Central (Sales), how do I… Keep Shipped Sales Orders
In Microsoft Dynamics 365 Business Central (Sales), how do I… Assign Number Series in Sales
Using Extended Texts In Microsoft Dynamics 365 Business Central: Create a Sales Transaction with Manually Added Extended Texts
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Understand For What Power Automate can be Used
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Know What Types of Flows Are Available
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Know What Actions Are Available with Power Automate
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Know What Triggers Are Available with Power Automate
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Know What Flow Templates Are Available from Microsoft
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Create Environment Variables for the Environment and Company
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Create a Flow For a Selected Record
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Create a New Cloud Instant Flow
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for when a Business Event Occurs
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… An Alternative to Environment Variables
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for an Approval
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for a Record on Create
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Create a New Cloud Flow for Business Central From a Template
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for a Record on Delete
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for a Record on Modification
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for a Record Change
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Understand Business Central Power Automate Actions
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Get record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Get url V3" Action
In the "For a selected Record V3" Microsoft Dynamics 365 Business Central Trigger in Power Automate, the Record URL is Avalable Without Using "Get url V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Find records V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Find One record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Update Record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Create Record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Delete Record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "List Companies V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Run Action V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Get Adaptive Card V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Get an Image, File or Document V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Update an Image, File or Document V3" Action
In Microsoft Dynamics 365 Business Central (Development), how do I… How to Upload an Extension

In Microsoft Dynamics 365 Business Central (Power Automate), how do I…

In Microsoft Dynamics 365 Business Central (Power Automate), how do I…
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Understand For What Power Automate can be Used
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Know What Types of Flows Are Available
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Know What Actions Are Available with Power Automate
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Know What Triggers Are Available with Power Automate
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Know What Flow Templates Are Available from Microsoft
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Create Environment Variables for the Environment and Company
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Create a Flow For a Selected Record
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Create a New Cloud Instant Flow
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for when a Business Event Occurs
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… An Alternative to Environment Variables
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for an Approval
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for a Record on Create
In Microsoft Dynamics 365 Business Central (Power Automate), how do I… Create a New Cloud Flow for Business Central From a Template
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for a Record on Delete
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for a Record on Modification
In Microsoft Dynamics 365 Business Central (Power Automate Triggers), how do I… Create a Flow for a Record Change
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Understand Business Central Power Automate Actions
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Get record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Get url V3" Action
In the "For a selected Record V3" Microsoft Dynamics 365 Business Central Trigger in Power Automate, the Record URL is Avalable Without Using "Get url V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Find records V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Find One record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Update Record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Create Record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Delete Record V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "List Companies V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Run Action V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Get Adaptive Card V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Get an Image, File or Document V3" Action
In Microsoft Dynamics 365 Business Central (Power Automate Actions), how do I… Use the "Update an Image, File or Document V3" Action

Continue reading “In the “For a selected Record V3” Microsoft Dynamics 365 Business Central Trigger in Power Automate, the Record URL is Avalable Without Using “Get url V3” Action”

New Functionality In Microsoft Power Automate 2024 Wave 2: Scale Faster With Process Mining Thin Client App

Power AutomateThis post is part of the New Functionality In Microsoft Power Automate 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 2.

The 1st of the new functionality in the Process mining section is scale faster with Process Mining thin client app.

The current Power Automate Process Mining app requires you to download the process model to the client computer. This download puts specific requirements on the hardware resources on the client computer. To unblock your resources, you can use the Azure Process Intelligence Analytic Service instead. With this service, you can use a lightweight desktop app with a process intelligence engine without the need to download the process model. The functionality of the thin desktop application offers features that are identical to the previous full desktop app. This allows you to scale faster, it supports larger process models, and doesn’t put specific requirements on your computers.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: Sep 2024
General Availability: Nov 2024

Feature Details

Process Intelligence Analytic Service offers analytical functions in the form of an Azure API. When the desktop application connects to Process Intelligence Analytic Service, you have access to the identical functionality as in the full Power Automate Process Mining desktop app.

With Power Automate Process Mining thin client app, there’s no need to:

  • Download the process model, which takes up your resources.
  • Fulfill special hardware requirements when working with large process models.
  • Install desktop application updates in case of analytical operation modifications.

Click to show/hide the New Functionality In Microsoft Power Automate 2024 Wave 2 Series Index

New Functionality In Microsoft Power Automate 2024 Wave 2: Use Copilot To Ask Power Automate Product Questions

Power AutomateThis post is part of the New Functionality In Microsoft Power Automate 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 2.

The 6th of the new functionality in the Desktop flows section is use Copilot to ask Power Automate product questions.

Use Copilot’s comprehensive understanding of Power Automate to explore new possibilities and potentially optimize your workflows. Boost your productivity by getting answers to your questions regarding features like conditions, approvals, and flow recovery.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview:  May 21, 2024
General Availability: Dec 2024

Feature Details

The automation center is available in the Power Automate portal and offers a comprehensive automation monitoring experience infused with the power of AI. Copilot in automation center provides a multi-skill experience enabling users to ask questions about cloud flow and desktop flow activity, work queues, and even features of Power Automate.

Copilot can answer Power Automate product related questions like:

  • How can I add a condition in Power Automate desktop?
  • Can cloud flows handle approvals and decision-making processes?
  • Where can I find deleted flows in Power Automate?

Click to show/hide the New Functionality In Microsoft Power Automate 2024 Wave 2 Series Index

New Functionality In Microsoft Power Automate 2024 Wave 2: Use Copilot To Analyze Work Queue Data

Power AutomateThis post is part of the New Functionality In Microsoft Power Automate 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 2.

The 5th of the new functionality in the Desktop flows section is use Copilot to analyze work queue data.

The automation center is available in the Power Automate portal and offers a comprehensive automation monitoring experience infused with the power of AI. With Copilot’s ability to answer questions about work queue statuses and handling times, you can enhance processing throughput and resiliency as well as understand and prevent SLA breaches.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview:  May 21, 2024
General Availability: Dec 2024

Feature Details

Copilot in automation center provides a multi-skill experience enabling users to ask questions about cloud flow and desktop flow activity, work queues, and even features of Power Automate.

Copilot can answer work queue related questions like:

  • Show me the number of items that are on hold.
  • Show me the number of items that are at risk of breaching SLA.
  • What’s the average handling time per processor (machine) and queue?

Click to show/hide the New Functionality In Microsoft Power Automate 2024 Wave 2 Series Index

New Functionality In Microsoft Power Automate 2024 Wave 2: Use Copilot To Analyze Desktop Flow Runs

Power AutomateThis post is part of the New Functionality In Microsoft Power Automate 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 2.

The 4th of the new functionality in the Desktop flows section is use Copilot to analyze desktop flow runs.

The automation center is available in the Power Automate portal and offers a comprehensive automation monitoring experience infused with the power of AI. Maximize efficiency and focus on high-impact desktop flow automation with Copilot’s insightful analysis of desktop flow run history.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview:  May 21, 2024
General Availability: Dec 2024

Feature Details

Copilot in automation center provides a multi-skill experience enabling users to ask questions about cloud flow and desktop flow activity, work queues, and even features of Power Automate.

Copilot is able to answer desktop flow run history questions like:

  • Which flows ran the most last week?
  • What were yesterday’s top five flows by number of completed runs?
  • What is the distribution of flow run statuses?

Click to show/hide the New Functionality In Microsoft Power Automate 2024 Wave 2 Series Index

New Functionality In Microsoft Power Automate 2024 Wave 2: Use Copilot To Analyze Cloud Flow Runs

Power AutomateThis post is part of the New Functionality In Microsoft Power Automate 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 2.

The 3rd of the new functionality in the Desktop flows section is use Copilot to analyze cloud flow runs.

Copilot in automation center provides a multi-skill experience enabling users to ask questions about cloud flow and desktop flow activity, work queues, and even features of Power Automate. With Copilot, unlock a deeper understanding of cloud flow trends, statuses, and performance by simply asking questions in natural language.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview:  May 21, 2024
General Availability: Dec 2024

Feature Details

The automation center is available in the Power Automate portal and offers a comprehensive automation monitoring experience infused with the power of AI.

Copilot can answer cloud flow run history questions like:

  • How many runs last month were triggered by another cloud flow?
  • Who initiated flow runs during the last month?
  • How many flows failed yesterday?

Click to show/hide the New Functionality In Microsoft Power Automate 2024 Wave 2 Series Index

New Functionality In Microsoft Power Automate 2024 Wave 2: Monitor, Manage Your Automations And Related Assets

Power AutomateThis post is part of the New Functionality In Microsoft Power Automate 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 2.

The 2nd of the new functionality in the Desktop flows section is monitor, manage your automations and related assets.

The automation center provides comprehensive automation monitoring experiences across Power Automate flows, infused with the power of AI and Copilot. It provides in-depth monitoring and troubleshooting capabilities for both experienced makers and citizen developers, as well as members of the Center of Excellence.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview:  May 21, 2024
General Availability: Dec 2024

Feature Details

With top-level automation monitoring, you can gain an end-to-end view of your automation status. The dedicated work queue monitoring area allows you to closely track SLA attainment, average processing time, and work queue throughput.

The automation center includes a multi-skilled copilot enabling users to ask questions about cloud flow and desktop flow activity, work queues, and features of Power Automate.

Click to show/hide the New Functionality In Microsoft Power Automate 2024 Wave 2 Series Index

New Functionality In Microsoft Power Automate 2024 Wave 2: Use Cyberark Credentials In Desktop Flow Connections

Power AutomateThis post is part of the New Functionality In Microsoft Power Automate 2024 Wave 2 series in which I am taking a look at the new functionality introduced in Microsoft Power Automate 2024 Wave 2.

The 1st of the new functionality in the Desktop flows section is use CyberArk credentials in desktop flow connections.

You can now use credentials stored in CyberArk Central Credential Provider when connecting to Windows sessions on desktop flow machines.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: Jun 2024
General Availability: Oct 2024

Feature Details

Users can leverage credentials stored in Cyberark Central Credential Provider to connect to Windows sessions on desktop flow machines. Credentials are not stored in Power Automate but retrieved during runtime. This feature supports rotating passwords without the need to update the connection.

Click to show/hide the New Functionality In Microsoft Power Automate 2024 Wave 2 Series Index