cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rohinMVP
Resolver I
Resolver I

Read Excel content without tables

I have some excel files in a SharePoint folder that I have to process using a flow.

 

The flow works nice if a table is added for the content in the file.

 

Is it possible to read the added content in the excel and process it, if the data is without a table?

Users might miss to add the tables; however the columns would remain the same in all the files.

8 REPLIES 8
Pstork1
Dual Super User III
Dual Super User III

As far as I know there is no way to read data in an Excel File without using tables.



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
ScottShearer
Super User
Super User

@rohinMVP 

I agree with the comments made by @Pstork1 .  You might want to distribute a template that includes tables to your users.

If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

Scott
Paulie78
Super User
Super User

Hi @rohinMVP you can read and update Excel workbooks without the data having to be in a table with the use of Excel Scripts. Can you provide a bit more detail about the actions you want to perform and I will try to create something to get you started.

 

I've only been using Office Scripts a short while, but they are very powerful.

hi @Paulie78 , so Excel scripts can be added within a Flow?

 

I want to read the data in some columns and put them into another file.

Each of the files would have less than 10 rows.

Paulie78
Super User
Super User

@rohinMVP You prepare the Office Scripts first, and then run them. Would the files always have the same number of columns?

 

Examples of things you can do with Office Scripts from my blog (but do not do what you want):

https://www.tachytelic.net/2021/03/power-automate-sort-array/

https://www.tachytelic.net/2021/03/power-automate-sum-array/

 

Another one from @DamoBird365  which does add data:

https://damobird365.birdhoose.co.uk/2021/03/24/power-automate-office-scripts-populate-an-excel-templ...

 

Paulie78
Super User
Super User

@rohinMVP  if you can provide a sample worksheet with layout and data similar to what you want to read, I will produce a script that will do what you want.

abm
Super User
Super User

Hi @rohinMVP 

 

There is an action step called 'Create Table' in Power Automate.

 

image.png



Did I answer your question? Mark my post as a solution!

If you liked my response, please consider giving it a thumbs up


Proud to be a Flownaut!

Learn more from my blogPower Automate Video Tutorials

@Paulie78I have a worksheet with 20 columns with 5-7 rows of text data.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Users online (2,388)