cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KCarlton96
Helper I
Helper I

Power Automate Get File Content not working as expected when pulling from an Excel file with multiple sheets

So I have an excel file with two sheets, each sheet has a table on it.

 

I am using the get file content component to pull the content of this file to create an array of attachments. 

KCarlton96_2-1616195831731.png

 

KCarlton96_1-1616195720175.png

The first sheet of the file attached to the email is perfect, but the second sheet only contains one row, when the original file contains at least thirty on that sheet.

 

Does anyone know how to fix this?

 

1 ACCEPTED SOLUTION

Accepted Solutions
mahoneypat
Solution Sage
Solution Sage

You could try the Get Tables action for Excel which will give you an array of the tables in the workbook with which you could do an Apply To Teach and then List Rows from each table, etc.

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


View solution in original post

2 REPLIES 2
mahoneypat
Solution Sage
Solution Sage

You could try the Get Tables action for Excel which will give you an array of the tables in the workbook with which you could do an Apply To Teach and then List Rows from each table, etc.

 

Regards,

Pat





Did I answer your question? Mark my post as a solution! Kudos are also appreciated!

To learn more about the Power Platform, follow me on Twitter or subscribe on YouTube.


@mahoneypa HoosierBI on YouTube


How would that work with respect to creating the attachment array though?

Helpful resources

Announcements
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

MPA Licensing.jpg

Ask your licensing questions at the Power Automate AMA!

Join Priya Kodukula and the licensing team, super users and MVPs to find answers to your questions on Power Automate licensing.

Users online (3,525)