cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
helena11
New Member

Searching for keywords in Microsoft Power Automate Desktop

I want to search some keywords in pdf and excel files, for example name, surname, age, etc. If these words are mentioned in that pdf or excel file, I will write the path of that pdf and excel file to the text file.
I am having trouble searching for keywords. I do not know what actions to use. Can you help with this?
Thanks in advance.

2 REPLIES 2
FrankBergeron
New Member

Hi helena11, finally have you found a solution? 

JHanscombe
Regular Visitor

HI,

 

For PDFs i built the below:

 

JHanscombe_0-1658366903748.png

this may help then you just need to update the variables to what you need as for the Excel, you could use the same IF loop but with the read from excel worksheet. you'll notice this is written only for PDFs at this stage. it also outputs it all as a msg box which you could change to be a txt document / CSV with their related actions. 

Helpful resources

Announcements
 WHAT’S NEXT AT MICROSOFT IGNITE 2022

WHAT’S NEXT AT MICROSOFT IGNITE 2022

Explore the latest innovations, learn from product experts and partners, level up your skillset, and create connections from around the world.

Register for a Free Workshop.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Users online (1,462)