Skip to main content

Notifications

Community site session details

Community site session details

Session Id : UdesVcWt6iHFieTP/l23br
Power Automate - General Discussion
Suggested answer

Using Power Automate to get file contents from excel worksheet

Like (1) ShareShare
ReportReport
Posted on 30 Apr 2024 04:43:53 by 6

hi , i am trying to get file contents of desired excel worksheet from excel file and i want to create a new excel file using collected file content in another location ( sharepoint library).  

i am able to get the desired excel worksheet id and name. from there i would like to retrieve the file contents but i am not able to find any option to retrieve. 

 

P.S : i cannot use excel get rows function since my data is not in table format and i could not run scrip to make a table since it will destroy design requirements and formulas. 

 

 

 

 

image.png

  • Suggested answer
    takolota1 Profile Picture
    4,863 Super User 2025 Season 1 on 06 Oct 2024 at 23:13:09
    Using Power Automate to get file contents from excel worksheet
    You can also use this template Azure Function to pull data from any Excel sheet without the need for table formatting...
    https://community.powerplatform.com/galleries/gallery-posts/?postid=eea06380-8483-ef11-ac21-7c1e5201b42f

    Or if you need something without premium connectors, then you can use these Office Script templates…
  • thihan27 Profile Picture
    6 on 30 Apr 2024 at 20:19:48
    Re: Using Power Automate to get file contents from excel worksheet

    hi @AlexEncodian thanks for the solution but unfortunately i do no think my company would like to spend on subscription for one flow only.

  • thihan27 Profile Picture
    6 on 30 Apr 2024 at 20:18:48
    Re: Using Power Automate to get file contents from excel worksheet

    hi @SudeepGhatakNZ thanks for the suggestion and i only need to copy one worksheet of the whole file, is it doable with copy file sorry i am pretty new to power automate. 

     

  • SudeepGhatakNZ Profile Picture
    14,318 Most Valuable Professional on 30 Apr 2024 at 05:45:15
    Re: Using Power Automate to get file contents from excel worksheet

    @thihan27 Can you not use the Copy action in SharePoint to copy the file itself instead of copying the contents?

    If you want to copy a subset of the data, convert your excel to a CSV. You can build the formulas in power automate if needed.

    SudeepGhatakNZ_0-1714455906596.png

     

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 the Engage with the Community forum!

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Warren Belz – Community Spotlight

We are honored to recognize Warren Belz as our May 2025 Community…

Leaderboard > Power Automate - General Discussion

#1
stampcoin Profile Picture

stampcoin 23

#2
Pstork1 Profile Picture

Pstork1 20 Most Valuable Professional

#3
Gprior Profile Picture

Gprior 19

Overall leaderboard