Power Automate: intersection Function
Returns items common to multiple arrays. Works with numbers, strings, and objects.
Welcome to my Microsoft hub, the starting point for everything I write about the Microsoft ecosystem. Here you'll find tutorials, references, and practical tips across the Microsoft 365 and Power Platform family, grouped into focused areas so you can jump straight to what you need. If you build automations, start with Power Platform, where I cover Power Automate, Power Apps, and Power BI. For everyday productivity, browse Excel for formulas and data tricks, Microsoft Teams for collaboration, and Microsoft Planner and Microsoft To Do for keeping tasks organized. Working with data and files? OneDrive, Microsoft Lists, and Microsoft Forms each have their own space with hands-on guides. Developers and admins can dig into Microsoft Graph and PowerShell for scripting across SharePoint, Azure, and Microsoft 365. I also cover Microsoft 365 Copilot, Microsoft Outlook, OneNote, and Shifts, showing how these products fit together in real workflows.
Returns items common to multiple arrays. Works with numbers, strings, and objects.
Fires when you are mentioned in a specific Teams channel. Polling-based.
Merges arrays and removes duplicates.
Updates a Planner task with Percent Complete, Bucket Id, and 25 category fields.
Returns a given number of items from the front of an array or string.
Removes a given number of items from the front of an array.
Returns items from an array that match a condition. Supports AND/OR logic.
Sorts an array in ascending order by value or property.
Loops until a condition is met. Always runs at least once; has iteration limits.
Reverses the order of items in an array.