This 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.