Thank you. I face pdf files that contain multiple tables with wild structures: We have a table with 3 columns: Column headings + 1 row of data. This table is immediately followed by a seperate set of data comprising 4 columns. PAD treats them as a single table with 4 columns.
I need to Extract the table from PDF but PDF table is not a table format it looks like table,i used extract table from PDF unable to get entire data,any other option
Thank you for this! It was very useful for me, but I've a question, is it possible in the flow, just choice the table instead all information, I mean, I just need the table with the info (Item, quantity, Unit Cost and amount), Can I obtain it?
@@gustarinanurfadilah2436 For this one, you can select the table index directly. So forget about the "For each" loop. Just : Extract table from PDF Write table with index X (the one u're interested in)
You use "get files in folder", and then you iterate with for each. Basically something like this : For each file in list_of_files: - open excel - extract table from "file" (the variable) - write to excel - save
Oh.... We need more local content creator like u. Please share more tips and methods of PAD and it's usage to improve productivity.
Thanks for your encourage. Do remember to subscribe to our channel :)
Thank you! This will save me hours when trying to find out how many rows are in a table.
You are welcome!
the best, channel for Powe Automate Desktop, i'm learning a lot.
Your videos are amazing. Thank you so much.
Compliments! Great job, really well done... thank you
Amazing! Thank you!
Glad you liked it!
Great Video. Thank you so much.
Thank you. I face pdf files that contain multiple tables with wild structures: We have a table with 3 columns: Column headings + 1 row of data. This table is immediately followed by a seperate set of data comprising 4 columns. PAD treats them as a single table with 4 columns.
I need to Extract the table from PDF but PDF table is not a table format it looks like table,i used extract table from PDF unable to get entire data,any other option
Thank you for this! It was very useful for me, but I've a question, is it possible in the flow, just choice the table instead all information, I mean, I just need the table with the info (Item, quantity, Unit Cost and amount), Can I obtain it?
i have the same case, how to do it ?
@@gustarinanurfadilah2436 For this one, you can select the table index directly.
So forget about the "For each" loop.
Just :
Extract table from PDF
Write table with index X (the one u're interested in)
How do we save all the data in single excel sheet and how to give multiple pdfs as input
Have tried Extract PDF Tables action but won’t work if there’s a password in pdf file.
Do you know how to extract multiple PDF at once using "get files in folder"? or is there any other more efficient way to do it?
You use "get files in folder", and then you iterate with for each. Basically something like this :
For each file in list_of_files:
- open excel
- extract table from "file" (the variable)
- write to excel
- save
🎉
Will this work for scanned pdf as well?
Hi! Currently Power Automate for Desktop only supports digital documents.
Not clearly visible
Does this work for 1000 PDF?
Can you please post the entire thing as a file so that we can download and use jt
Your videos are amazing. Thank you so much.
Thanks for viewing the video. Good automating!