New Functionality In Microsoft Power Automate 2024 Wave 1: Use New Excel Actions in Power Automate for Desktop

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

The 24th of the new functionality in the Desktop Flows section is use new Excel actions in Power Automate for desktop.

This group of newly introduced actions simplify the authoring process and enables makers to construct Excel flows more intuitively, preventing the need for complex logic.

Enabled for: Admins, makers, marketers, or analysts, automatically
Public Preview: –
Early Access: –
General Availability: Jul 2024

Feature Details

The actions pane now includes the following dedicated Excel actions:

  • Get table range
  • Set range color
  • Copy worksheet
  • Append range
  • Look up range
  • Read cell formula
  • Auto fill range

These actions provide new capabilities previously unavailable, empowering makers to enhance their desktop flows involving Excel, one of the most common categories for automation.

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

New Functionality In Microsoft Power Automate 2024 Wave 1: Use New Data Table Actions

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

The 23rd of the new functionality in the Desktop Flows section is Use new data table actions.

This collection of newly introduced actions reduces the time spent on authoring and assists makers in avoiding the need for complex logic when creating flows that have specific data table requirements.

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

Feature Details

The actions pane now includes the following dedicated actions for data tables:

  • Clear Data table
  • Delete column on Data table
  • Filter Data table
  • Sort Data table
  • Add column in Data table
  • Join Data tables
  • Merge Data tables
  • Remove Duplicate rows in Data table
  • Remove Empty rows in Data table
  • Output Data table to text
  • Generate data table from text

These actions empower users to manage data table variables, as needed, eliminating the necessity for workarounds in their relevant use cases.

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