📎 This article includes 1 downloadable practice file ↓
Advertisement
One email per row is spam. Collect rows, then send one summary.
| Action | Does |
|---|---|
| Filter array | Keep items matching a condition: item()?['Status'] is equal to Submitted |
| Select | Reshape each item: map Claim = ClaimID, Who = Employee, Rs = Amount |
| Create HTML table | Turns the Select output into a table for an email body |
| Join | Array to text: join(body('Select'), ', ') |
| length() | How many: length(body('Filter_array')) |
Select + Create HTML table needs no loop at all, so it’s faster and simpler than Apply to each with Append to string variable.
When you do loop
- Apply to each > Settings > Concurrency control (e.g. 10) runs iterations in parallel: much faster for independent items.
- Don’t use concurrency when the loop appends to a variable; order and totals can go wrong.
💡 Nested Apply to each (each email → each attachment) is normal. Name actions clearly (“Each attachment”) or expressions become unreadable.
Practice
Build a flow that emails one HTML table of all Submitted claims. Build it in your own Microsoft 365 account at make.powerautomate.com, test it with the practice file, and check the run history.
📎 Practice files for this article
- 📄Expression cheat sheet14 expressions with checked example results.⬇ TXT · 2 KB
Free to use for learning. Files with macros (.bas) are plain text — import them with Alt+F11 → File → Import File, and always test on a copy.
Advertisement
✨ Ask AI about this article
Stuck on a step? Ask a question and the AI answers using this article.
Free · AI can be wrong