Learn the concepts.
Use the tools as reference.
Three comprehensive guides that teach you how things actually work in Power Automate and Power BI, not just what buttons to click, but the logic behind it so you can apply it to any situation.
Power Automate Expressions
Understand exactly what expressions are, how the editor works, and how to use every function category. String manipulation, date formatting, logical branching, type conversion, and reading data from flow context, all covered with real examples you can copy immediately.
- concat, substring, replace
- formatDateTime, addDays, utcNow
- if, and, or, equals
- body(), triggerOutputs(), items()
- Null checks and coalesce patterns
Array & Collection Actions
Master the built-in Data Operations and Control actions that most makers underuse. Learn when to use Select over Apply to Each, how Filter Array works, how to parse and compose JSON, and how to turn arrays into tables and strings, without writing complex expressions.
- Apply to Each vs Select
- Filter Array with conditions
- Parse JSON and schema
- Compose, Join, Create HTML Table
- Nested loops and performance tips
Power BI Expressions (DAX)
Learn DAX from the ground up. Understand the difference between DAX and Power Query M, when to write a measure vs a calculated column, and how CALCULATE works. Covers aggregations, time intelligence, filtering, and the most useful patterns every BI developer needs.
- Measures vs calculated columns
- SUM, COUNT, CALCULATE, FILTER
- TOTALYTD, SAMEPERIODLASTYEAR
- % of total and ranking patterns
- DAX vs M: which to use
After reading, use the Power Platform Toolkit to apply what you learned: build OData filters, test expression functions, look up errors, and explore connectors.