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?
CATEGORY

Reference

This is my reference library, the place I send people when they need precise, dependable answers about how a specific function, action, or trigger actually behaves. Tutorials teach you a workflow, but a reference tells you exactly what a piece does, what it expects, and where it bites. My Excel Function Reference breaks down worksheet functions like the "Count" function with clear syntax and examples. The Power Apps Function Reference covers the Power Fx functions you use to build canvas apps, and the SharePoint List Function Reference explains the calculated column functions that shape list data. For automation, the Power Automate Trigger Reference documents how each trigger fires, while the N8N Node Reference and N8N Trigger Reference do the same for the open-source world. An OData Reference handles the query syntax for filtering and sorting data. Every page delivers real syntax, real parameters, and the gotchas I have hit.

Power Automate: item Function

Power Automate: item Function

4 min read · 4 years ago

Accesses each element inside repeating actions like Apply to Each.

Power Automate: Planner - Create a task action

Power Automate: Planner - Create a task action

6 min read · 4 years ago

Creates a Planner task: group, plan, title, dates, assignments, and labels.

Power Automate: Manually Trigger a Flow Trigger

Power Automate: Manually Trigger a Flow Trigger

10 min read · 4 years ago

Runs a Flow on demand with typed input parameters.

Power Apps: WeekNum function

Power Apps: WeekNum function

3 min read · 4 years ago

Returns the week number for a date. Start day is configurable.

Power Automate: Planner - List Tasks Action

Power Automate: Planner - List Tasks Action

5 min read · 4 years ago

Returns all tasks from a Planner plan as an array.

Power Automate: Office 365 Outlook - When a new email arrives Trigger

Power Automate: Office 365 Outlook - When a new email arrives Trigger

9 min read · 4 years ago

Fires when a new email arrives in any Outlook folder.

SharePoint: AVERAGE function

SharePoint: AVERAGE function

4 min read · 4 years ago

Returns the arithmetic mean of number columns. Up to 30 parameters.

Power Automate: Planner - Get a task Action

Power Automate: Planner - Get a task Action

5 min read · 4 years ago

Returns a Planner task: title, dates, assignments, tags, and completion percentage.

Power Automate: Forms - When a new response is submitted Trigger

Power Automate: Forms - When a new response is submitted Trigger

3 min read · 4 years ago

Fires when a Forms response is submitted. Returns the response ID only.

Power Automate: trim function

Power Automate: trim function

2 min read · 4 years ago

Removes leading and trailing spaces. Inner spaces stay intact.

Power Automate: Planner - Update a task Action

Power Automate: Planner - Update a task Action

7 min read · 4 years ago

Modifies a Planner task: title, dates, progress, and assignments.

Power Apps: ISOWeekNum function

Power Apps: ISOWeekNum function

2 min read · 4 years ago

Returns the ISO week number for a date. Monday is the first day; week 1 contains the first Thursday.

← Previous Page 11 of 20 Next →
  • Home
  • Blog
  • Recommendations
  • About
  • Privacy Policy
  • Cookie Policy
  • Contact
  • Livro de Reclamações

© 2026 Skillful Sardine - Unipessoal Lda. All rights reserved.