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.
As far as I know there is no way to read data in an Excel File without using tables.
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.
@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):
Another one from @DamoBird365 which does add data:
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Congratulations, the new Super User Season 2 for 2021 has started!
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.