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
Learn how to create your own user groups today!
Check out the new Power Platform Community Connections gallery!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.