Skip to main content
Community site session details

Community site session details

Session Id : aha/UFOFCizGCZYiP8VMvg
Power Automate - General Discussion
Unanswered

Request for Power Automate Method to Retrieve Excel File Column Count

Like (0) ShareShare
ReportReport
Posted on 28 Feb 2024 16:23:18 by 40

I'm seeking suggestions on how to efficiently determine the number of columns in an Excel file using Power Automate. I need a method or expression that can accurately count the columns present in the Excel file retrieved through Power Automate.

Any recommendations or techniques would be greatly appreciated

  • Nived_Nambiar Profile Picture
    17,978 Super User 2025 Season 2 on 28 Feb 2024 at 18:44:15
    Re: Request for Power Automate Method to Retrieve Excel File Column Count

    Hi @Gowtham_Tamilan 

     

    Try the office script for this >

     

    see below post for reference- https://powerusers.microsoft.com/t5/General-Power-Automate/Excel-table-column-count/td-p/959604

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

  • Gowtham_Tamilan Profile Picture
    40 on 28 Feb 2024 at 18:25:11
    Re: Request for Power Automate Method to Retrieve Excel File Column Count

    Yes. that's correct .. I need to get no of column in Excel file.

  • Nived_Nambiar Profile Picture
    17,978 Super User 2025 Season 2 on 28 Feb 2024 at 17:54:00
    Re: Request for Power Automate Method to Retrieve Excel File Column Count

    Hi @Gowtham_Tamilan 

     

    One thing to confirm-> you want to count the number of columns present in table in excel file ?

     

    Thanks & Regards,

    Nived N 🚀

    LinkedIn: Nived N's LinkedIn
    YouTube: Nived N's YouTube Channel

    🔍 Found my answer helpful? Please consider marking it as the solution!
    Your appreciation keeps me motivated. Thank you! 🙌

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

Quick Links

Announcing our 2025 Season 2 Super Users!

A new season of Super Users has arrived, and we are so grateful for…

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!

Leaderboard > Power Automate

#1
Tomac Profile Picture

Tomac 986 Moderator

#2
stampcoin Profile Picture

stampcoin 699 Super User 2025 Season 2

#3
Riyaz_riz11 Profile Picture

Riyaz_riz11 577 Super User 2025 Season 2

Loading complete