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.
Excellent example, could you explain an additional feature like make a loop for process a whole folder plenty of pdf files and put the data in the same excel work sheet?? thanks in advance
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)
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
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 :)
the best, channel for Powe Automate Desktop, i'm learning a lot.
Thank you! This will save me hours when trying to find out how many rows are in a table.
You are welcome!
Your videos are amazing. Thank you so much.
Thanks for viewing the video. Good automating!
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.
Compliments! Great job, really well done... thank you
Excellent example, could you explain an additional feature like make a loop for process a whole folder plenty of pdf files and put the data in the same excel work sheet?? thanks in advance
Good video.
Could you please make a video on how to insert logo or image to pdf page at desired location.
Amazing! Thank you!
Glad you liked it!
Great Video. Thank you so much.
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.
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
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
Can you please post the entire thing as a file so that we can download and use jt
Does this work for 1000 PDF?
Your videos are amazing. Thank you so much.