I had a flow to read pdf and then use RegEx to search keyword data, write into Excel. If all the pdf also is the same format that is fine to me. But my finally purpose is this flow can handle different format pdf, for example PDF 1 has 3 field I need, Item Name, Color and Repeat Size. PDF 2 has 6 field I need, Item Name, Pattern, Article No, Color, Finish and Remarks.
PDF 1 has 3 field
Create Data Table store the value
Create another Data Table for output using array and for each row to write into excel
output Excel like this
PDF 2 has 6 field
How can I create all known field and get value when read different pdf ?
Final output want to like this when I read both PDF 1 and 2
Also upload my project for you all reference
Main.xaml (14.5 KB)
pdf2.pdf (382.0 KB)
pdf1.pdf (481.0 KB)