Hi,
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.
Problem:
The main problem is when I tried to create a table in the excel, in a specific worksheet the flow don't do nothing.
Result:
FLOW:
Could you please help?
thank you
hi @Kamacete mmm I'm not excel expert but the range you have says 2003!A1:b1, and for me a valid range is just A1:B1
Proud to be a Flownaut!
@ChristianAbata thank you for your answer.
But, how can I identify one worksheet from others?
I have several worksheets in the same excel.
oh @Kamacete is a worksheet is ok, mmm just to ask my friend your table name is called Source2 right?
Proud to be a Flownaut!
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
Proud to be a Flownaut!
Hi again
Differences #3, #4 #5 doesn't seem to influence the result
Hope this helps
Proud to be a Flownaut!
Hi again
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?
Thanx!
Proud to be a Flownaut!
@efialttes I did the same test for 5 sheets and my flows gets a delay @Kamacete I think this is an normally performance flow.
Proud to be a Flownaut!
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
@Kamacete far as I know unfortunally not my friend just all the worksheets all the content
Proud to be a Flownaut!
this is the result
could you please share the flow that you do with me?
The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.
Announcing a new way to share your feedback with the Power Automate Team.
Learn to digitize and optimize business processes and connect all your applications to share data in real time.
User | Count |
---|---|
73 | |
26 | |
20 | |
15 | |
15 |
User | Count |
---|---|
144 | |
44 | |
44 | |
34 | |
31 |