Skip to main content
Manuel T Gomes

Automation Expert and Software Engineer

Home
Microsoft ▾
  • Power Automate
  • Power Apps
  • SharePoint
  • More ▸
    • Planner
    • Teams
    • Forms
    • Lists
    • Excel
    • Outlook
    • OneDrive for Business
    • Shifts
    • OneNote
    • To Do
    • PowerShell
Apple ▾
  • Xcode
  • Shortcuts
Python
Reference ▾
  • Power Automate Functions
  • Power Automate Actions
  • Power Automate Triggers
  • Power Apps Functions
  • SharePoint List Functions
  • OData Reference
  • N8N Triggers
  • Excel Functions
  • Power Automate Cookbook
  • Expressions Cookbook
Tools Newsletter Need Help?

Reading comfort

Set it once. We'll remember it for every visit.

Text size
Theme
Reduce motion
CATEGORY

Power Automate

Welcome to my Power Automate hub, where I share what I have learned building real cloud flows for work and for fun. If you have ever stared at a flow that almost works, this is where you fix it. You will find practical, hands-on guides that go beyond the basics and tackle the messy parts of automation. I cover advanced error handling patterns so your flows fail gracefully, and I dig into API rate limits and throttling, including batch operations and throttling mitigation, so your flows keep running when you scale up. I walk through building a website monitor from scratch, handling CSV files without losing your mind, and troubleshooting dynamic content when the values you expect simply are not there. My best practices for SharePoint across multiple environments save painful mistakes, and my approval workflow guide makes one of the most requested features easy to understand.

New Power Automate now requires connection references

New Power Automate now requires connection references

5 min read · 3 days ago

Convert a solution flow from a direct connection to a connection reference and unlock the new designer.

Power Automate: parseDateTime function

Power Automate: parseDateTime function

13 min read · 5 days ago

Converts a date string into an ISO 8601 timestamp using a locale and optional format. Locale comes second.

How to insert multiple values into a SharePoint Lookup field?

How to insert multiple values into a SharePoint Lookup field?

5 min read · 6 days ago

Writes multiple values into a SharePoint lookup column by mapping each tag to its list item ID.

Power Automate: Office 365 Outlook - Get emails Action

Power Automate: Office 365 Outlook - Get emails Action

11 min read · 1 week ago

Returns an array of emails from a mailbox folder. Filter fields only scan the first 250 emails.

Power Automate: convertTimeZone function

Power Automate: convertTimeZone function

14 min read · 1 week ago

Converts a timestamp between two time zones, daylight saving included. Output drops the zone marker.

SharePoint Permissions in Power Automate

SharePoint Permissions in Power Automate

9 min read · 1 week ago

Which account really runs each action, and why a flow that works for you returns 403 for everyone else.

Power Automate: Office 365 Outlook - Export email Action

Power Automate: Office 365 Outlook - Export email Action

11 min read · 2 weeks ago

Exports an Outlook email as a binary EML file by Message ID. Attachments are included inside the file.

Power Automate: getFutureTime function

Power Automate: getFutureTime function

11 min read · 2 weeks ago

Returns the current timestamp plus a number of time units. Always counts from UTC now.

How to check optional values in a manual trigger?

How to check optional values in a manual trigger?

5 min read · 2 weeks ago

Read optional manual trigger inputs safely with ?[] and avoid the missing-property error.

How to save emails from an Outlook to a file in Power Automate

How to save emails from an Outlook to a file in Power Automate

9 min read · 3 weeks ago

Saves an email as an .eml file, automatically as it arrives or manually in bulk from a folder.

SharePoint Copy File Action

SharePoint Copy File Action

16 min read · 3 weeks ago

Copies a file to another library or site. Version history and metadata don't carry over.

Power Automate: convertFromUtc function

Power Automate: convertFromUtc function

11 min read · 3 weeks ago

Converts a UTC timestamp into a target time zone. Returns a string with no offset or Z marker.

← Previous Page 1 of 27 Next →
Manuel T Gomes

Helping teams and developers plan, build, and automate, and sharing what I learn along the way.

No ads. No third-party trackers. Written by a human.

Topics

  • Power Automate
  • Reference
  • Python
  • SharePoint
  • Apple & Shortcuts

Site

  • Blog
  • Recommendations
  • Newsletter
  • About
  • Contact

Legal

  • Privacy Policy
  • Cookie Policy
  • Livro de Reclamações
© 2026 Skillful Sardine, Unipessoal Lda. All rights reserved. From Portugal to the World.