Use new Excel actions in Power Automate for desktop

Important

Some of the functionality described in this release plan has not been released. Delivery timelines may change and projected functionality may not be released (see Microsoft policy). Learn more: What's new and planned

Enabled for Public preview Early access General availability
Admins, makers, marketers, or analysts, automatically - - Jul 2024

Business value

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.

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.