Every day I received an email with attach (Excel with several worksheets). I have to save the attach in SharePoint and extract the information existing in one worksheet to another excel.
The main problem is when I tried to create a table in the excel, in a specific worksheet the flow don't do nothing.
Could you please help?
@ChristianAbata thank you for your answer.
But, how can I identify one worksheet from others?
I have several worksheets in the same excel.
With the example I just implemented, it is working fine.
THe potential differences I find are:
1.-It took to your flow 5 secs to read your Worksheets, in my case the excel was simple, it just took 1 sec. MAybe you should add a delay action block, let's say 10 secs in between, just in case.
2.- My excel file has a single Worksheet
3.- I defined two rows, you defined just once
4.- I use capital letters to define range
5.- I didn't add a semicolon at the end of the Column List
Hope this helps
I just added manually a second sheet to my excel file, now my flow creates the table in 'Hoja1' instead of 'Hoja2'.
So either the error you got is a random one; or the delay is needed for bigger files than mine, or... how many excel sheets do you currently have in your excel file?
I have 4 worksheets, but maybe I see this from a wrong perspective.
Is there any way to get the information from the worksheet without a table and insert the data into an existing excel, with just a worksheet and table?
if yes, this solve my problem
Check out the News & Announcements to learn more.
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.