N8N: Gmail Trigger
Starts a workflow when a new email arrives in Gmail. Polls on a schedule; filter by label, sender, or search.
TAG
Into The Weeds
Some articles go a good deal deeper than the rest, and I call those Into the Weeds. This is where I take on complex topics, the behaviors you need to be careful about, and the trickier issues that are a pain to fix. I write them for two reasons. The first is to give advanced users something meatier to sink into and solve real problems with. The second is to give people who are still learning the Power Platform a richer experience by putting harder material within reach. Even if you do not need it today, you will remember that these corners are tricky, and when you hit something similar in a project you will save yourself hours of confusion. Going into the weeds can burn a lot of time, and my aim is to spare you some of those headaches.
Power Automate: slice Function
Extracts a substring by position. Supports negative indices; endIndex is exclusive.
The reason it's EMail and not Email or email in Power Automate
Explains why SharePoint's email field is spelled EMail and why the casing breaks your filters
Power Apps: LookUp Function
Returns the first record that matches a condition, or a single reduced value. Blank if nothing matches.
SharePoint: MONTH function
Returns the month of a date as a number from 1 to 12. Empty date fields return 12
How to stop an infinite trigger loop in Power Automate?
Stop a flow from re-triggering itself with trigger conditions, flag columns, or a create-only trigger.
Dynamic Content Troubleshooting in Power Automate
The capital M that breaks your SharePoint Person column filter
Pydantic HTTPX2 - What's new and how to take proper advantage of it?
How to fix the unexpectedly did not find the new dependency in the package graph
How to Validate if a GUID is Valid in Power Automate
SharePoint - Create File Action
Creates a file in a SharePoint document library from text or binary content.