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 About Need Help?

Reading comfort

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

Text size
Theme
TAG

Fundamentals

If you want to master something, you have to understand its fundamentals deeply. They are the building blocks you stand on to reach the more complex ideas. Knowledge is like a house: you lay strong foundations first, then build upward. It sounds like a cliche, but it holds true, and solid fundamentals are what make good professionals. Under this tag I work on bringing you the fundamentals of each technology, from the small details that quietly make all the difference to the bigger concepts. My focus is mostly the Power Platform, but I will happily write about other things I find interesting along the way. Expect a mix drawn from technology and productivity. What matters most to me is that you walk away having learned something new you can build on.

Power Automate: Office 365 Excel - Add a key column to a table action

Power Automate: Office 365 Excel - Add a key column to a table action

7 min read · 3 years ago

Adds a key column to an Excel table so other Excel actions can reference rows.

Power Automate: uriScheme function

Power Automate: uriScheme function

4 min read · 3 years ago

Returns the protocol from a URL: 'https', 'ftp', or any valid scheme.

Power Automate: What is a Key Column in Excel?

Power Automate: What is a Key Column in Excel?

4 min read · 3 years ago

Power Automate: Office 365 Excel - Delete Row action

Power Automate: Office 365 Excel - Delete Row action

10 min read · 3 years ago

Removes a row from an Excel table by key column value.

Power Automate: Office 365 Outlook - Get email action

Power Automate: Office 365 Outlook - Get email action

7 min read · 3 years ago

Returns an Outlook email by Message ID.

Power Automate: uriPathAndQuery function

Power Automate: uriPathAndQuery function

4 min read · 3 years ago

Returns the full path and query string from a URL.

Power Automate: uriPath function

Power Automate: uriPath function

4 min read · 3 years ago

Returns just the path segment from a URL.

How to solve the JSON Invalid type error in Power Automate?

How to solve the JSON Invalid type error in Power Automate?

10 min read · 3 years ago

Power Automate: OneDrive for Business - When a file is modified (properties only) Trigger

Power Automate: OneDrive for Business - When a file is modified (properties only) Trigger

7 min read · 3 years ago

Fires when a OneDrive file is modified. Returns metadata only, not content.

Power Automate: startOfMonth function

Power Automate: startOfMonth function

4 min read · 3 years ago

Returns the first day of any month.

Power Automate: OneDrive for Business - When a file is created (properties only) Trigger

Power Automate: OneDrive for Business - When a file is created (properties only) Trigger

7 min read · 3 years ago

Fires when a OneDrive file is created. Returns metadata only, not content.

Power Automate: OneDrive for Business - Create file action

Power Automate: OneDrive for Business - Create file action

6 min read · 3 years ago

Creates a file in OneDrive for Business.

← Previous Page 5 of 19 Next →
Manuel T Gomes

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

Topics

  • Power Automate
  • Python
  • SharePoint
  • Apple & Shortcuts

Site

  • Home
  • Blog
  • Recommendations
  • About
  • Contact

Legal

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