Answered

Extract Text from PDF File in variable

(0) Share

Report

Posted on by memphis111

Hello, everyone,

I am currently trying out a few things with the Power automate desktop. Now I have a question about extract text from PDF
If I read out an invoice and write it into a text file, it works directly. Now my question, is it possible to write the evaluated lines in a variable?
Example:

ROW1: Day 27.09.2021
ROW2: Number 5556
ROW3: Adress
ROW4: Company
ROW5: Company Name
ROW6: Street
ROW7: Ort

Would like to transfer the individual lines to an Excel table later

greetings

Categories:

Power Automate Desktop

All responses (3)

Answers (2)

Sort by

Verified answer

Henrik_M 2,021 Super User 2024 Season 1 on at

Like
a
(2)

Report
Copy link

Link copied!

It is.

Use a Split text (standard delimiter: new line) which outputs a list, then use Write to Excel worksheet with that list as an input. The cell that you specify will then hold the first item of the list, while the cell below will hold the second list item, etc.
Verified answer

memphis111 54 on at

Like
a
(0)

Report
Copy link

Link copied!

That's it, thank you very much
memphis111 54 on at

Like
a
(0)

Report
Copy link

Link copied!

I have to ask again, how do I get certain lines read out when all the values are now under each other in the Excel table?
So line 10, line 12 and line 23