web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Power Platform Community / Forums / Power Automate / How Can I Extract Emai...
Power Automate
Unanswered

How Can I Extract Email from PDF/Text File

(0) ShareShare
ReportReport
Posted on by

I'm trying to make a flow which, once a file is uploaded to a certain Sharepoint folder, would first parse the PDF to find the emails to send it to, then send it by Email. The file format is as follows:

 

https://imgur.com/eo2xbUu

 

Since I want to extract the content of the PDF file's first page, I'm using Power Automate Desktop. Now that I have a text file with the first page, I want to be able to extract only the emails. One way I found to do this is by using the following: https://powerusers.microsoft.com/t5/General-Power-Automate/Flow-Find-Isolate-Value-within-a-String/td-p/402416 in Power Automate, or composing a function, 

trim(split(split(body('Html_to_text'),'Email:')[1],'Phone Number:')[0])

to get the substring between Email and Phone Number. I want to use the same logic (or any other, really), but from a text file, and I also am not sure how the function would look on the Desktop application. Any help is appreciated!

Categories:
I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Power Automate

#1
Michael E. Gernaey Profile Picture

Michael E. Gernaey 501 Super User 2025 Season 2

#2
Tomac Profile Picture

Tomac 323 Moderator

#3
abm abm Profile Picture

abm abm 237 Most Valuable Professional

Last 30 days Overall leaderboard