Skip to main content
News and Announcements icon
Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate - Building Flows / How to get data from E...
Power Automate - Building Flows
Unanswered

How to get data from Excel named ranges

(0) ShareShare
ReportReport
Posted on by WebPortal 2,278

I'm exploring the many things we can do with Power Automate, and I couldn't find a way to import data from Excel named ranges.

Is there a way to do this?

Thanks for helping!

  • JerryNorbury Profile Picture
    JerryNorbury 2 on at
    Re: How to get data from Excel named ranges

    Did that work?

  • Joe_Laz Profile Picture
    Joe_Laz 18 on at
    Re: How to get data from Excel named ranges

    Did it work or did you find a workaround?

     

    Currently, I'm trying to understand how to pull named ranges using Power Query.

  • WebPortal Profile Picture
    WebPortal 2,278 on at
    Re: How to get data from Excel named ranges

    Well ok..

     

    Perhaps we could build the Excel table linked to the named ranges and assign each cell to a variable in PA. I'll give it a try.

  • Paulie78 Profile Picture
    Paulie78 8,416 Super User 2025 Season 1 on at
    Re: How to get data from Excel named ranges

    As of right now, I believe this is not possible. You can only work with tables. 😥

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2
Welcome to the Power Platform Communities

Quick Links

Paul Stork – Community Spotlight

We are honored to recognize Paul Stork as our July 2025 Community…

Congratulations to the June Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 497 Super User 2025 Season 1

#2
David_MA Profile Picture

David_MA 436 Super User 2025 Season 1

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 244 Super User 2025 Season 1

Last month Overall leaderboard

Featured topics

Start and wait for an approval action

Product updates

Microsoft Power Platform Community release plans