Extract multiple file PDf in one folder to excel

Hello, need help…i have case to extract PDf with regex, i created flow to extract pdf in one file pdf and its working well (main.xaml) And For result excel its like below:
Main.xaml (13.1 KB)
image

And now i need to extract more than one file in same folder to extract, i have create flow(extractMultiFilesPDf), but its still getting erorr. Please advise.

Thanks in advance.

ExtractMultiFilesPDF.xaml (14.4 KB)

can you try this

ExtractMultiFilesPDF.xaml (14.6 KB)

regards

still eror
image

write range Workbook activity should be outside of for each activity…

can you please check the varaibles of getFCR,getInvGGI and other varaibles placed in add datarow

Whatever you are trying to right in the array isn’t their ie its blank and it won’t accept blank input.

Suggest writing each element you are extracting to a textfile and checking which one isn’t present

still cannot

no idea for this…

check the regex with text in the pdf are you getting any output or not

if still you face any issue please sample pdf files with expected output

Edit - Also try change value in data row in this way {getFCR,getInvGGI,getInvExpd,getValueVAT}

Regards

Please See my first post in this thread, i have create Flow to exctract with 1 file PDF(main.xaml), and running well, see also in screen shoot.

@supermanPunch can you help me?thank you… :smiley:

try as above it will work

Regards

still eror
image

ExtractMultiFilesPDF.xaml (14.7 KB)

see this is not the file i gave , you are not providing output to read pdf activity

so i made some adjustments and created separate variable to avoid this

in this way it will not work right?

so better make changes as provided

Regards

sory wrong attch file, i have make correction for this. stil showing eror like before
ExtractMultiFilesPDF.xaml (14.8 KB)

you have changed the in read pdf activity but again missed giving that to matches activity

so change input for all matches activity with the output of read pdf activity

also still if you face issue please provide details at what activity you are getting error

along with total error details in locals panel

Regards

sory my bad… i have changed all the matches with the variable on read PDF, stil getting error, the activy is in add data row, like below

there are two dtoutput datatable

try deleting the first and try again now

Regards

thanks @LAKSHMI_NARAYANA_PEMMASAN its working now… many thanks

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.