Power Automate Desktop to "Find and Replace" text across workbooks

[@hwlttpckrd]

first time not learn from indian tutorial.. keep make tutorial bruh. its good

[@davidababurko5963]

Victor you are an incredible man!!!! This flow right here was pivotal in the ability for us to be able to migrate our folders to SharePoint without breaking any links Love the sense of humour too!!

[@ExcelMoments]

Thank you so much . Appreciate the compliment. I am glad you also found it useful and helpful

[@davidgallant4245]

Great video Victor. Really easy to follow and produced the result I was looking for in my own project on the first try. Thanks for the help.

[@ExcelMoments]

Glad you found it helpful. Thanks for the feedback

[@aakifahmed8212]

Hi victor thanks for the video Just a question How can we dynamically change both the find and replace value in find and replace step instead of directly mentioning in the flow Like I want to change both the find and replace value dynamically My use case I have separate file where all the masters are captured in an array like Column A column B chocolate | dark bars Cookies | biscuits Soft drinks | beverage I want to check this file take column A value(cookies) as find value and replace it with corresponding column B value(biscuits) in all my files then take second value soft drinks etc till my master comes to an end Would really appreciate if you could assist me in the solution.

[@dancirillo]

Hello! Great Video! Thanks!! It's possible to do the same with word files? Thanks!!

[@ExcelMoments]

Unfortunately not. with this exact approach, as the action is specific to Worksheets. But surely, this can be done with say VBA

[@pipapo8670]

Hello brother, great video! It was very helpful :) I have one question: let’s say I want to find ‚Chocolate sweet‘ , ‚Chocolate salty‘ so ‚Chocolate xyz‘ and replace it with only ‚Chocolate‘ How do I tell the bot Chocolate (xyz)? So how do I define a placeholder for text? Is it * ? Thank you so much! Appreciate your videos.

[@ExcelMoments]

Thank you for the feedback. You are spot on there, using the asterisk will help you achieve what you seek, same way we use wildcards in Excel

[@Mahmoudalgindy]

Wow I am the first viewer 😂

[@ExcelMoments]

Thats great. Quite fast