About Power Automate Lab

About Me

Welcome! I’m Eduardo, and I created Power Automate Lab to share practical automation patterns that actually get used in production – not just demo flows.

I work as an automation lead in an investment department, where I use Power Automate to automate workflows around trading, reporting, and operations for fixed income and equity investments. Day to day, that means turning messy, manual processes into reliable, repeatable flows.

I’ve been working with automation and business software since 2005, across industries like:

  • Business software development
  • Logistics
  • Media / publishing
  • Investment and financial services

Over the years I’ve used many different tools and platforms, but Power Automate has become my go-to for connecting systems and getting real work done without heavy custom code.

What You’ll Find Here

Power Automate Lab is focused on real-world, end-to-end solutions. The tutorials and scripts on this site are based on things I actually build and support, such as:

  • Automating Excel-based reporting with Power Automate and Office Scripts
  • Building reliable flows with proper error handling and logging
  • Designing flows for trading and investment reporting scenarios
  • Reusable script snippets you can plug directly into your own automations

Whenever possible, I include:

  • Step-by-step screenshots
  • Reusable expressions and scripts
  • Explanations of why something is done a certain way, not just how

Who This Site Is For

Power Automate Lab is for you if:

  • You build or support Power Automate flows at work
  • You work with Excel, SharePoint, or data-heavy reports
  • You want patterns and best practices you can trust in production
  • You’re comfortable experimenting, but you don’t want to reinvent the wheel every time

Whether you’re just starting with Power Automate or already building complex flows, my goal is to give you clear, reusable building blocks.

How to Use the Tutorials

A few tips to get the most out of the site:

  • Start with the Best Practice articles to see how I structure flows and handle errors.
  • Use the Scripts category to grab small, focused script snippets (especially for Excel Office Scripts).
  • Adapt everything to your own environment – file paths, data sources, and security requirements will always be specific to your organization.

If you run into a problem or need a variation of a tutorial, feel free to reach out.

Contact & Feedback

If you have questions, ideas for new topics, or found a tutorial helpful and want to say hi, I’d love to hear from you.

Thanks for visiting Power Automate Lab – I hope the content here saves you time, helps you avoid a few pitfalls, and makes your automations a little more powerful and reliable.