
Announcements
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:
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!