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 new user group experience and if you are a leader please create your group
May the fourth be with you, join us online!
See the latest Power Automate innovations, updates, and demos from the Microsoft Business Applications Launch Event.
ISV Studio is the go-to Power Platform destination for ISV’s to monitor & manage applications post-AppSource publish.